Bob Pawley wrote:
Thank you. What clause is acceptable??
INSERT has no conditional clause. You send INSERT, it goes to the database -- the database either accepts it or rejects it (unique key violations, bad data, etc).
If you want to INSERT if some value = 'xxx', wrap an IF THEN statement around it.
---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org