Thanks man; Iappreciate the data. Stephan Szabo wrote:
> > On Thu, 9 Jan 2003, Jack Flak wrote: > >> Stephan, >> >> That's very interesting! I didn't even know about these other "hidden" >> fields. How many others are there? > > Let's see, I think the set is > ctid, oid, xmin, cmin, xmax, cmax, tableoid > > IIRC, > ctid is basically like a physical pointer to where the row actually is > oid you know > xmin - transaction that made the row > cmin - command counter in that transaction that made the row > xmax, cmax - like xmin, cmin but for the transaction that removes it > tableoid - which table it belongs to (for inheritance) > > Cmin and xmax share storage, and it looks like xmin/xmax are of a type > that you can't actually do much with from an SQL statement. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
