blackwater dev wrote:
In MySQL, I can use the replace statement which either updates the
data there or inserts it. Is there a comporable syntax to use in
postgreSQL?
I need to do an insert and don't want to have to worry about if the
data is already there or not...so don't want to see if it th
nuno wrote:
>hi, there. i'm trying to write a SQL statement which does the following
>things.
>
>1. checks if data already exists in the database
>2. if not, insert data into database otherwise skip.
>
>
>
Check this thread :
http://archives.postgresql.org/pgsql-general/2005-10/msg01787.php
DETAIL: Key (id)=(1) is not present in table "a".
========
Thanks
Kostas Maistrelis.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org