Postgres Pro
Downloads
Home   >   mailing lists

Re: creating a function returning FALSE on NULL input ? - Mailing list pgsql-general

From Yvon Thoraval
Subject Re: creating a function returning FALSE on NULL input ?
Date
Msg-id CAG6bkBz_p1=OYe=y+zi8kyZRptjKyeCg4PgN9VZMV+o6GTdd2w@mail.gmail.com
Whole thread Raw
In response to Re: creating a function returning FALSE on NULL input ?  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
Tree view
Fine, thanks it's shorter than mine and works too.
I'll adopt it ))



2012/11/7 Alban Hertroys <haramrae@gmail.com>
On 7 Nov 2012, at 6:33, Yvon Thoraval wrote:

> CREATE FUNCTION has_infos(text) RETURNS boolean AS 'select character_length($1) > 0;' LANGUAGE SQL IMMUTABLE RETURNS FALSE ON NULL INPUT;

Try:
CREATE FUNCTION has_infos(text) RETURNS boolean AS 'select coalesce(character_length($1) > 0, false);' LANGUAGE SQL IMMUTABLE;

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.




--
Yvon


pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: creating a function returning FALSE on NULL input ?
Next
From: Andres Freund
Date:
Subject: Re: Comparing txid_current() to xmin