[lug] (OT) postgresql
davis_compz at hotmail.com
Sun Nov 10 15:21:29 MST 2002
is there a postgresql select query i can enter to specify
the last row of a table...i.e. i want to make a new invoice number based
on the inv_num field of the last customer entry into a table.the only thing
i can think off is to run a loop on the data base using perl to increment
a var + 1 for every row in the table...then use this var to get a query
to the last row...hope this is coherent :)
jd at taproot.bz
"Who you trying to get crazy with essay?
Don't you know I'm loco?"
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
More information about the LUG