Re: "anyelement2" pseudotype - Mailing list pgsql-hackers

From Matt Miller
Subject Re: "anyelement2" pseudotype
Date
Msg-id 1171471926.27919.1174623763@webmail.messagingengine.com
Whole thread Raw
In response to Re: "anyelement2" pseudotype  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > adding an "anyelement2" pseudotype ... The context was a
> > compatibility SQL function to support Oracle's DECODE function.
>
> The reason it's not in there already is we didn't seem to have quite
> enough use-case to justify it.  Do you have more?

No.  Even this case, for me, is more an expedient than a necessity. I
could just rewrite my Oracle code to use CASE, but I've a lot of code to
convert, and the transformation is a bit error prone.  I'm also looking
at a scripted code edit to rewrite the Oracle stuff, and comparing this
to the cost a PG compatibility function.


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: NULL and plpgsql rows
Next
From: Tom Lane
Date:
Subject: Re: Plan for compressed varlena headers