Postgres Pro
Downloads
Home   >   mailing lists

Re: Can I trigger an action from a coalesce ? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Can I trigger an action from a coalesce ?
Date
Msg-id 35c60adc-3f02-13ad-a4a6-48642a1185d8@aklaver.com
Whole thread Raw
In response to Can I trigger an action from a coalesce ?  (stan <stanb@panix.com>)
Responses Re: Can I trigger an action from a coalesce ?  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
Tree view 
On 2/22/20 1:02 PM, stan wrote:
> I have a case where if a value does not exist, I am going to use a default,
> which is easy with coalesce. But I would like to warn the user that a
> default has been supplied. The default value is reasonable, and could
> actually come from the source table, so I can't just check the value.
> I'd like to do a raise NOTICE, if the default portion of the coalesce fires.
> 
> Anyone have a good way to accomplish this?

No.


-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: stan
Date:
Subject: Can I trigger an action from a coalesce ?
Next
From: Christophe Pettus
Date:
Subject: Re: Can I trigger an action from a coalesce ?