Re: Extending COALESCE()

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hello

I am afraid, so this isn't possible. You have to use a explicit cast
"int to bool"

select coalesce(true, 0::bool)

regards

Pavel Stehule

2010/11/23 David Frankson <David.Frankson@xxxxxxxxxxxxxxxxxx>:
> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general