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
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 |