Dear Sir/Madam,
I would like to find out two things:
1)Do you have a function which is similar to Oracle\'s DECODE.
2) Can you extract day of week (Monday,etc) from yours date functions.
Kind Regards,
Jack Kiss
Jack Kiss <jackkiss@ecluboz.com> writes:
> 1)Do you have a function which is similar to Oracle\'s DECODE.
Yes
> 2) Can you extract day of week (Monday,etc) from yours date functions.
Yes
Check out the "Date/Time Function and Operators" and the "Conditional
Expressions" sections of this:
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/functions.html
--
greg