Re: conditional insert - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: conditional insert
Date
Msg-id 4E649AFC.2060909@iol.ie
Whole thread Raw
In response to conditional insert  (Pau Marc Muñoz Torres <paumarc@gmail.com>)
List pgsql-general
On 05/09/2011 10:38, Pau Marc Muñoz Torres wrote:
> Hi follk
>
>  i trying  to performe a  conditional insert into a table, indeed, what
> i'm trying to do is not insert a record into the table if that record exist
>
> googleling i found something like
>
>  insert into XX values (1,2,3) where not exist (select ....);
>
> but i'm having and error near where...
>

Shouldn't it be EXISTS, not EXIST?

Anyway, what is the error you're getting?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: conditional insert
Next
From: Thomas Kellerer
Date:
Subject: Re: conditional insert