[lug] (OT) postgresql

j davis 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?"

-Cypress Hill

Add photos to your e-mail with MSN 8. Get 2 months FREE*. 

More information about the LUG mailing list