Re: INSERT WHERE NOT EXISTS - Mailing list pgsql-general

Because

>>select exists(select * from tablename where [cond])

will return after finding 1 matching row (or am I
wrong ?) while

> SELECT 1 FROM tablename WHERE [cond];

will return a 1 for *each* matching row (just tested).

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346