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 there, if so
> do update if not insert...etc.
>
> Thanks.
>
In Oracle this is called the MERGE statement, but it not yet in pg. It
is on the TODO list, though.