Find min and max values across two columns?

From: Amos Hayes <ahayes(at)polkaroo(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Find min and max values across two columns?
Date: 2006-03-24 20:19:38
Message-ID: DAD4674C-1896-4F24-B43B-B884491DB931@polkaroo.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello. I've recently begun to use PostgreSQL in earnest (working with
data as opposed to just having clever applications tuck it away in
there) and have hit a wall with something.

I'm trying to build a query that among other things, returns the
minimum and maximum values contained in either of two columns. The
problem is that min() and max() only take one column name as an
argument. Is there some clever way that I can craft an expression to
find the min/max across both columns? I have yet to delve into any
pgsql so if it requires that, then please go easy on me. :)

Example:

id | columnA | columnB
1 | 4 | 2
2 | 3 | 4
2 | 5 | 1

I'd like to be able to discover that 1 is the smallest value in
either columnA or columnB and 5 is the largest. I don't actually care
what rows they are in, I just want the values.

Thanks for your time! Any help or pointers to relevant reading
material on this would be greatly appreciated. (I have been using the
excellent PostgreSQL docs and an equally good book titled Beginning
Databases with PostgreSQL by Neil Matthew and Richard Stones so far.)

--
Amos

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message MaXX 2006-03-24 20:30:56 generate_series to return row that doesn't exist in table...
Previous Message george young 2006-03-24 20:07:03 Re: Custom type