Re: Inquiry From Form [pgsql]

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Jack Kiss <jackkiss(at)ecluboz(dot)com>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Inquiry From Form [pgsql]
Date: 2003-03-02 14:10:25
Message-ID: 87y93xkgfi.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Jack Kiss <jackkiss(at)ecluboz(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Stark 2003-03-02 14:19:08 Re: Dynamic SELECT condition
Previous Message Denis Zaitsev 2003-03-02 09:24:01 default operator class (PostgreSQL's error?)