Re: mapping date value (SQL question) - Mailing list pgsql-general

You have in plpgsql the ability to use IF THEN ELSIF ELSE

Also in pure SQL you can use the CASE WHEN THEN END

Example: Case Statement

CASE WHEN status = 1 THEN Draft
     WHEN status = 2 THEN Open
     WHEN status = 3 THEN Complete
     WHEN status = 4 THEN Closed
ELSE undefined
End AS status

Example: PLPGSQL

    IF subject = ''Location'' THEN
       /* Code goes here */
    ELSIF subject = ''Device'' THEN
       /* Code goes here */
    ELSE
       /* Code goes here */
    END IF;

Hope this helps

Darren Ferguson

On Thu, 21 Feb 2002, Johnson, Shaunn wrote:

> Howdy:
>
> I'm running Postgres 7.1.3 on RedHat Linux 7.2, kernel version
> 2.4.7 rel 10.
>
> I've created a table which includes the date.  I have been instructed
> to map the date into something that reflects the quarter of the year
> on the fly (somewhere in the script).  For example:
>
> (currently) date:        (needed) quarter:
> 2001-02-26            200101
> 1998-05-12            199802
> 803-11-11            80304
>
> I was thinking I'd have to use something like a case statement, but
> I don't know enough about SQL to do something like that.  Somehow, I
> had the notion that if it were possible to write 'if-then-else' loops
> I could probably do it.
>
> Is there such a mechanism to do what is being asked of me?
>
> Thanks!
>
> -X
>