|
Is it possible to extend the COALESCE() function? I would like
to support for coalescing an int into a Boolean, but I get syntax errors if I
don’t wrap coalesce in quotes. CREATE OR REPLACE FUNCTION coalesce(boolean,int) RETURNS
boolean AS $$ SELECT CASE WHEN $1 IS NOT NULL THEN $1 WHEN
$2 = 1 THEN true ELSE false END $$ LANGUAGE sql IMMUTABLE; Thanks, Dave |
