Yvon Thoraval <yvon.thoraval@xxxxxxxxx> writes: > CREATE FUNCTION has_infos(text) RETURNS boolean AS 'select > character_length($1) > 0;' LANGUAGE SQL IMMUTABLE RETURNS FALSE ON NULL > INPUT; FWIW, "RETURNS NULL ON NULL INPUT" is a formulaic phrase specified in the SQL standard. It's not meant to be something you can plug an arbitrary value into --- it has to be written exactly that way. The traditional Postgres term is just "STRICT", which means precisely the same thing. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
