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
>