Re: Can I trigger an action from a coalesce ?
От
Adrian Klaver
Тема
Re: Can I trigger an action from a coalesce ?
Дата
Msg-id
35c60adc-3f02-13ad-a4a6-48642a1185d8@aklaver.com
Ответ на
Список
Дерево обсуждения
Can I trigger an action from a coalesce ? stan <stanb@panix.com>
Re: Can I trigger an action from a coalesce ? "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Can I trigger an action from a coalesce ? "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Re: Can I trigger an action from a coalesce ? "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Can I trigger an action from a coalesce ? Adrian Klaver <adrian.klaver@aklaver.com>
Re: Can I trigger an action from a coalesce ? Christophe Pettus <xof@thebuild.com>
Re: Can I trigger an action from a coalesce ? stan <stanb@panix.com>
Re: Can I trigger an action from a coalesce ? Christophe Pettus <xof@thebuild.com>
Re: Can I trigger an action from a coalesce ? Tom Lane <tgl@sss.pgh.pa.us>
Re: Can I trigger an action from a coalesce ? Christophe Pettus <xof@thebuild.com>
Re: Can I trigger an action from a coalesce ? Tom Lane <tgl@sss.pgh.pa.us>
Re: Can I trigger an action from a coalesce ? Christophe Pettus <xof@thebuild.com>
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 по дате отправления
