Hi,
I've setup a query in my program to get the biggest value used in my "customers" table. There is a serial column
calledcustomer_id. I use the following query within my program and it returns, lets say, 3. If I run the same query
fromthe psql console window (over and over and at the same point where I've stepped to in my program), it will
consistentlyreturn 2 whereas the program will consistently return 3 (always one more).
Here is the query to get the last ID used:
SELECT customer_id from customers order by customer_id DESC limit 1;
I do one fetch and have my result programmatically which is always 1 more than the value returned by the psql console
windowmethod. What gives?
Many thanks,
Mike