RE: [BUGS] 'order by' and 'desc' not working in subquery using 'not in'

2001-07-31 Thread Dong, Meng
Title: Hi Rahul,Have you tried to quote each table name and column name by  " , and constant by ' ? In your case, try delete from "reporttable" where ( "srvServerid" = 'serverid') and( "rptreportid" not in(select "rptreportid" from "reporttable"where ( "srvserverid" = 'serverid' order

[BUGS] 'order by' and 'desc' not working in subquery using 'not in'

2001-07-31 Thread pgsql-bugs
Rahul Gade ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description 'order by' and 'desc' not working in subquery using 'not in' Long Description Hello, I am facing two big problems,they may not be really big but in my case these are b