It worked - Thank you
Bob
----- Original Message -----
From: "William Yu" <wyu@xxxxxxxxxxx>
To: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, November 15, 2005 11:06 AM
Subject: Re: Is it databases in general, SQL or Postgresql?
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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
