Right now I have a query which uses decode function to get data in
Oracle database, I want know is there any alternative function to
decode which can do the decode functionality in Postgresql.
Oracle: decode (value, 0, 'zero', 1, 'one', 'unknown')
In PostgreSQL you have to use CASE WHEN Syntax:
Hi All,
Right now I have a query which uses decode function to get data in Oracle database, I want know is there any alternative function to decode which can do the decode functionality in Postgresql.
Thanks in advance for your great help.
Thanks
Babu Mannem
