Re: select items, and max id

On Thu, Aug 28, 2003 at 22:11:49 -0400,
  "Luis H." <pgsql-novice@geekhouse.no-ip.com> wrote:
> I have a table where each row has an id unique identifier (separate from the one postgreql does automatically). I
wantto be able to do a certain SELECT query returning various rows, and also be able to check what the maximum id was
amongthe rows in the result. Is it possible to do this all in the same query? Right now I do it in a very dumb way -- I
executethe query to get all the data, and then I re-execute it as a subquery and pull out the max(id).  

Yes and no. You won't be able to return rows and the max id of the rows
without effectively doing the query twice. However, you could order the
output rows by the id and check the first (or last depending on sort
direction) row to get the value you want.