[SQL] Question

2002-12-10 Thread Jonathan Man 



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

[SQL] convert NULL into a value

2002-12-11 Thread Jonathan Man 



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] Timeout for lock table

2003-07-01 Thread Jonathan Man 



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 
another user when I lock it on the second session?
 
Please help me, THX!!
 
 
JMAN
 

[SQL] SQL

2003-07-01 Thread Jonathan Man 



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