Hello! >On Tue, Aug 23, 2005 at 09:15:42AM -0400, Robert Treat wrote: >> On Tuesday 23 August 2005 08:39, Ilja Golshtein wrote: >> > >> > select ctid from aaa where ctid in (select ctid from aaa limit 10); >Aside from that, ctid is of type tid, and its equality operator >isn't hashable. It is the piece of knowledge I failed to deduce exploring plans of queries ;(. So I have no better solution then creating indexed field of serial type, have I? The only thing I am curios is ctid good for anything from user point of view? Thanks a lot. -- Best regards Ilja Golshtein ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
