Re: Please advise features in 7.1 (SUMMARY) - Mailing list pgsql-hackers

From Don Baccus
Subject Re: Please advise features in 7.1 (SUMMARY)
Date
Msg-id 3.0.1.32.20001130065521.0177d180@mail.pacifier.com
Whole thread Raw
In response to Re: Please advise features in 7.1 (SUMMARY)  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-hackers
At 05:24 AM 11/30/00 +0000, Thomas Lockhart wrote:
>> 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.

The insert, at least, can be written in standard SQL anyway...



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 


pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: SQL 'in' vs join.
Next
From: Tom Lane
Date:
Subject: Re: SQL 'in' vs join.