[SQL] SQL

Dear All,   May I execute a SQL to find out user's information (e.g. user id or ip address) who are connecting to a database?   THX!!     JMAN  

[SQL] Timeout for lock table

Dear All,   I begin a transaction. I then execute a SQL command "SELECT FOR UPDATE" to lock some records on the first session. Besides, I also lock some rows using the same method on the second session. Is it possible to return an error message to indicate that some records were locked by an

[SQL] convert NULL into a value

Hi,   There is a function on the Oracle. That is NVL(field, 0) to convert null into a value (e.g.  ZERO).   Can I use this function on the PostgreSQL??     Thank you for your help!!   Regards,   JONATHAN MAN

[SQL] Question

Hi,   Can I get a table structure on a function using pgsql??     Thank you very much!!   From JONATHAN MAN