File: cull_null.sql

package info (click to toggle)
postgis 1.3.3-3
  • links: PTS, VCS
  • area: main
  • in suites: lenny
  • size: 10,468 kB
  • ctags: 4,310
  • sloc: sql: 73,321; ansic: 35,513; xml: 6,160; java: 6,061; sh: 3,428; perl: 1,447; cpp: 987; makefile: 727; yacc: 276; python: 192
file content (8 lines) | stat: -rw-r--r-- 243 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
 
-- Returns the value passed, or an empty string if null.
-- This is used to concatinate values that may be null.
CREATE OR REPLACE FUNCTION cull_null(VARCHAR) RETURNS VARCHAR
AS $_$
BEGIN
    RETURN coalesce($1,'');
END;
$_$ LANGUAGE plpgsql;