Re: Missing feature - how to differentiate insert/update in plpgsql function?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: depesz(at)depesz(dot)com, Pgsql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Missing feature - how to differentiate insert/update in plpgsql function?
Date: 2017-02-15 14:24:14
Message-ID: 02d8c251-ffd5-c270-46ce-a340c6f81dc5@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/15/2017 06:05 AM, hubert depesz lubaczewski wrote:
> Hi,
> I have a function, in PostgreSQL 9.6, which does:
>
> INSERT INTO table () values (...)
> ON CONFLICT DO UPDATE ...;
>
> The thing is that the function should return information whether the row
> was modified, or created - and currently it seems that this is not
> available. Or am I missing something?

All I can think of is to use:

RETURNING pk

and see if that changed or not.

>
> Best regards,
>
> depesz
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2017-02-15 14:27:45 Re: Missing feature - how to differentiate insert/update in plpgsql function?
Previous Message hubert depesz lubaczewski 2017-02-15 14:05:02 Missing feature - how to differentiate insert/update in plpgsql function?