Horton

Re: Please advise features in 7.1 (SUMMARY)

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: xuyifeng <jamexu@telekbird.com.cn>
Cc: John Huttley <John@mwk.co.nz>, pgsql-hackers@postgresql.org
Date: 2000-11-30T05:24:14Z
Lists: pgsql-hackers 
> Is "if" clause support in PG?
> for example:
> "drop table aa if exist"
> "insert into aa values(1) if not exists select * from aa where i=1"

No. afaict it is not in any SQL standard, so is unlikely to get much
attention from developers.

                     - Thomas