[lug] (OT) postgresql

[j davis]

Hello,
  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 :)

thanks,
jd

jd at taproot.bz
http://www.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*. 
http://join.msn.com/?page=features/featuredemail