> Here is the appropriate documentation link, where they have an example:
> http://www.postgresql.org/docs/8.3/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
>
> The primary difference is that they use a loop, which is more robust. In
> theory, if you delete the record between when t
On Thu, 2008-09-25 at 18:25 +0200, A B wrote:
> My solution up till now has been a function with the
>
> BEGIN
> insert
> EXCEPTION WHEN OTHERS THEN
> update ...
> END;
Here is the appropriate documentation link, where they have an example:
http://www.postgresql.org/docs/8.3/static/
On Thu, Sep 25, 2008 at 10:25 AM, A B <[EMAIL PROTECTED]> wrote:
> Hello.
> I was just asked by a mysql-user how do you do
> insert . on duplicate key update
> (or however they have it in mysql) in postgresql, if you are going to
> Is it correct to assume that a function that is search
Hello.
I was just asked by a mysql-user how do you do
insert . on duplicate key update
(or however they have it in mysql) in postgresql, if you are going to
run commands from the command line?
My solution up till now has been a function with the
BEGIN
insert
EXCEPTION WHEN
