On Tuesday 23 August 2005 15:55, Alvaro Herrera wrote: > On Tue, Aug 23, 2005 at 06:02:05PM +0400, Ilja Golshtein wrote: > > The only thing I am curios is ctid good for anything from user point > > of view? > > No -- it changes far too frequently for that. Oh I dunno... In general I'd agree with you, but I've seen a couple of (some would say hackey) use cases where you use the ctid to iterate over the columns returned in a row in a plpgsql function... :-) -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match