Thread: Inquiry From Form [pgsql]

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