Re: [pgadmin-support] About decode function

try: select case sex when 'M' then 'Male when 'F' then Female' end from std Sim Hi, I have knowledge in Oracle.Now we are using postgresql..., In oracle... select decode(sex,'M','Male','F','Female') from std; It r

[pgadmin-support] About decode function

Hi, I have knowledge in Oracle.Now we are using postgresql...,   In oracle... select decode(sex,'M','Male','F','Female') from std; It retuns Male or Female.insted of M or F.   Now i want to use this function in postgresql?is there any posibility? please send me..,i am waitning for ur repl