[GENERAL] Need Help w/ Timestamps

Hi! I moved all of our PostGRE DBs from Windows to Linux last weekend. Everything went well, performance is great, BUT there is one issue that I need to solve. My problem is, that the precision for timestamps in Linux is greater than in Windows. That seems to be fine, but MS Access cannot handle

[GENERAL] PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea Value in stored procedure

Hi! I have the following scenario: Table: Fil_no BigSerial Fil_Namevarchar Fil_DataBytea Fil_HASHvarchar Trigger: Before Insert (in Pseudo Code) ...