Skip site navigation (1) Skip section navigation (2)

Re: tid_le comparison for tuple id (ctid) values?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gry(at)ll(dot)mit(dot)edu
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: tid_le comparison for tuple id (ctid) values?
Date: 2005-11-21 21:19:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
george young <gry(at)ll(dot)mit(dot)edu> writes:
>    update steps set x=x||'X' from steps s where steps.key1=s.key1 and steps.key2=s.key2 and step.ctid<s.ctid;

> But this fails because there is no less-than operator (or function) on
> type "tid".

Probably a good thing, too, since if there was it wouldn't have anything
reliable to do with the age of the tuple.

			regards, tom lane

In response to


pgsql-sql by date

Next:From: RobDate: 2005-11-21 21:47:51
Subject: Storing HTML in table
Previous:From: george youngDate: 2005-11-21 21:00:16
Subject: tid_le comparison for tuple id (ctid) values?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group