> > feature of that type. But random misfeatures such as the join syntax or
> > the decode() function are going to have a hard time getting accepted.
>
> But we have decode():
>
> test=> \df decode
> List of functions
> Result data type | Schema | Name | Argument data types
> ------------------+------------+--------+---------------------
> bytea | pg_catalog | decode | text, text
> (1 row)
>
> Is this a different decode?
Yes this is completly different. Oracle decode works like this:
decode(value, choice1, result1, choice 2, result2, ......, default_result)
it works this way:
case when value=choice1 then result1 when value=choice2 then result2 .... else default_result
end
The nice part is it has an varying number of arguments, and can used within "sort". Very useful sometimes.
Another one very useful oracle function is "nvl", the same like "coalesce", but a lot easier to write :-)