[SQL] Record Lock details

2004-04-23 Thread Denis P Gohel
Hi all, I am using PostgreSQL 7.3.1. Is there a data dictionary in Postgres from where i can get the info about locked rows of any table ? If possible the value of those locked record ? My situation is like: I have an ODBC application working on Postgres. There are Master child tables. I

Re: [SQL] staggered query?

2004-04-21 Thread Denis P Gohel
Hi Try this.. SELECT Col1 , Col2 FROM yourtable WHERE to_number(to_char(col1, 'SS'),'99') / 10 ) in (10,20,30,40,50,00); HTH Denis - Original Message - From: Vincent Ladlad [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 8:23 AM Subject: [SQL]