I ran into a situation with the query that needs to fetch the last record from the table.
The table schema wasn't really designed to support this, (no serial id, or anything else I could use)
so SQL makes use of max(create_date) which has a resolution of 1 second and thus allows for duplicate values.
I was thinking about using max(oid), but I don't know if there's any rotation or recycling possible there...
Can I assume that oid for any new record will be larger than oid on any other existing rows?
Thanks,
Michael.