Extending COALESCE() - Mailing list pgsql-general

From David Frankson
Subject Extending COALESCE()
Date
Msg-id DC57CFF048A13045B63DA5D831B526BC07F48EC8B2@ANDY.InfiniteCampus.com
Whole thread Raw
Responses Re: Extending COALESCE()  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general

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

pgsql-general by date:

Previous
From: Jim Kunkel
Date:
Subject: gap between error and cure
Next
From: Dan Kortschak
Date:
Subject: very basic SQL question