It worked - Thank you

Bob
----- Original Message ----- From: "William Yu" <[EMAIL PROTECTED]>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, November 15, 2005 11:06 AM
Subject: Re: [GENERAL] 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

Reply via email to