| From: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
|---|---|
| To: | "PostgreSQL (SQL)" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Finding Max Value in a Row |
| Date: | 2012-05-11 19:03:55 |
| Message-ID: | CAAQLLO6EhUi0OUi38BiH+qmgKqY+mY27_hGBQJiC5rbWorXQbw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I have a problem in SQL I don't know how to solve and while I'm sure
there are 100+ ways to do this in ANSI SQL, I'm trying to find the
most cleanest / efficient way. I have a table called 'users' and the
field 'users_id' is listed as the PRIMARY KEY. I know I can use the
COUNT function, then I know exactly how many records are listed but I
don't know what the maximum or highest numeric value is so that I can
use the next available # for a newly inserted record. Sadly the
architect of this table didn't feel the need to create a sequence and
I don't know how to find the highest value.
Thank you for any assistance!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Viktor Bojović | 2012-05-11 19:17:07 | Re: Finding Max Value in a Row |
| Previous Message | Thomas Kellerer | 2012-05-04 13:05:43 | Re: How change col name during query to use it in where clause |