Re: Conditional INSERT: if not exists

Hi,

why not simply put a where condition in you insert :

insert into table values (a,b)
where not exists (select a,b from table)



Don Morrison a écrit :
> I want to insert a row unless it exists already.  Do I have to write a
> stored procedure to do this?
>
> Thanks,
> Don
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>