Re: select items, and max id

On Thu, Aug 28, 2003 at 22:11:49 -0400,
"Luis H." <pgsql-novice(at)geekhouse(dot)no-ip(dot)com> wrote:
> I have a table where each row has an id unique identifier (separate from the one postgreql does automatically). I want to be able to do a certain SELECT query returning various rows, and also be able to check what the maximum id was among the 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 execute the 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.