I think you're looking for the 'ORDER BY' clause to use in your SELECT, e.g.,
SELECT * FROM person ORDER BY id
More examples, options, and explanation can be found at
http://www.postgresql.org/docs/postgres/sql-select.htm
Cheers.
Ed Loehr
Jesse Scott wrote:
> ... Once the user has completed the
> editing, I perform an UPDATE on that row with the new values, but now that
> row is moved to the end of the table, making the page that lists the users
> list them out of order (one of the fields is a sequential ID number). Is
> there anyway to do a "sort by" or something similar? Or do I need to set
> the ID number to be some sort of index type?