Re: coalesce and nvl question
От
Bruno Wolff III
Тема
Re: coalesce and nvl question
Дата
Msg-id
20040623184357.GB12411@wolff.to
Ответ на
Re: coalesce and nvl question (Simon Windsor)
Список
Дерево обсуждения
coalesce and nvl question Simon Windsor <simon.windsor@cornfield.org.uk>
Re: coalesce and nvl question Mike Mascari <mascarm@mascari.com>
Re: coalesce and nvl question Simon Windsor <simon.windsor@cornfield.org.uk>
Re: coalesce and nvl question Bruno Wolff III <bruno@wolff.to>
Re: coalesce and nvl question Simon Windsor <simon.windsor@cornfield.org.uk>
Re: coalesce and nvl question Doug McNaught <doug@mcnaught.org>
On Wed, Jun 23, 2004 at 19:10:05 +0100, Simon Windsor wrote: > Hi > > I understand that null and '' are different, and MySQL and Oracle > functions are confusing, but my question was not about replacing NULL > but replacing Empty strings. These are handled in MySQL/Oracle by the > same functions that do NULL checks. > > Is there a standard function in Postgres that replaces Empty strings, as > against a NULL value. Something like the following may suit your purposes: coallesce(nullif(inputstring,''), 'replacement value')
В списке pgsql-general по дате отправления
