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.