Re: [HACKERS] How to use nested select statements

2000-11-29 Thread Don Baccus
At 08:31 PM 11/29/00 +0530, Sanjay Arora wrote: >Well I want to use nested select statements ,is it possible. In PG 7.0 you can use subselects in the "where" clause. >Is there any counterpart for 'Sysdate from dual' as in Oracle You don't need "dual", just "select now()" will work. If you're

[HACKERS] How to use nested select statements

2000-11-29 Thread Sanjay Arora
Hello everybody First of all I wold like to thank you in advance because I am sure that I would get my answer immediately. Well I want to use nested select statements ,is it possible. Is there any counterpart for 'Sysdate from dual' as in Oracle with Regards Sanjay Arora