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(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
In response to
pgsql-hackers by date
|Next:||From: Andrew Snow||Date: 2000-11-30 15:05:01|
|Subject: RE: SQL 'in' vs join.|
|Previous:||From: Michael Fork||Date: 2000-11-30 13:38:32|
|Subject: Re: |