> Hello all, I'm new to this list so forgive me if this question get's asked
> a lot. (I did search the archives...)
A standard SQL reference might help a lot, since this is more in the
domain of SQL syntax than PostgreSQL help.
> 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?
Just add the 'ORDER BY' tag to the end of your query....
e.g. 'SELECT * FROM users ORDER BY seq_id_number'
... and it will return the results sorted by seq_id_number. (Of course,
replace this variable with whatever your sequential id number field is
actually called.)
HTH,
- Stan -