Please help: How to determine largest of two numbers in a query? - Mailing list pgsql-sql

From Greg Youngblood
Subject Please help: How to determine largest of two numbers in a query?
Date
Msg-id 2B9713A99045D211BB4E0008C75668692EA70C@SCORPEXC1.houstoncell.com
Whole thread Raw
Responses Re: [SQL] Please help: How to determine largest of two numbers in a query?
List pgsql-sql
I have a table with the following structure:
    yyyymmdd    int4
    key        char(16)
    value1        int4
    value2        int4

with the following sample data:
    yyyymmdd    key    value1    value2
    19981201    hello    32    16
    19981201    bye    29    64
    19981202    hello    16    20
    19981202    bye    23    13

What I need is to select the greatest between value1 and value2, so the
answer would be:
    yyyymmdd    key    value
    19981201    hello    32
    19981201    bye    64
    19981202    hello    20
    19981202    bye    23

I can do this via ODBC using access by creating a column which is defined as
IF(value1>value2,value1,value2) but that doesn't work in psql.

How can I make this work in psql?

Thanks
Greg

pgsql-sql by date:

Previous
From: "Gregory W Burnham"
Date:
Subject: Re: [SQL] Odd characters in inserted data...
Next
From: Adam Maddock
Date:
Subject: Re: [SQL] Please help: How to determine largest of two numbers in a query?