Re: [PATCHES] <> operator

2006-02-26 Thread Qingqing Zhou
"Neil Conway" <[EMAIL PROTECTED]> wrote > Attached is a patch that implements <> for the tid type. This is based > on a patch submitted by Mark Kirkwood in October of 2005. I added some > regression tests, avoided unnecessarily renumbering a few OIDs in the > system catalogs, and bumped the catver

Re: [PATCHES] <> operator

2006-02-28 Thread Neil Conway
On Mon, 2006-02-27 at 11:37 +0800, Qingqing Zhou wrote: > Does it make sense to implementation > or < for the tid type? I can't get too excited about it, but I wouldn't object if someone can see a use for it. -Neil ---(end of broadcast)--- TIP 4:

Re: [PATCHES] <> operator

2006-03-02 Thread Qingqing Zhou
"Neil Conway" <[EMAIL PROTECTED]> wrote > > Does it make sense to implementation > or < for the tid type? > > I can't get too excited about it, but I wouldn't object if someone can > see a use for it. > There might be another usage of tid < or >. Consider a heap with one middle page is broken, I

Re: [PATCHES] <> operator

2006-03-03 Thread Tom Lane
"Qingqing Zhou" <[EMAIL PROTECTED]> writes: > There might be another usage of tid < or >. Consider a heap with one middle > page is broken, I could save most of my data by doing > INSERT INTO aa SELECT * FROM a WHERE ctid < '(1000, 1)'; > INSERT INTO aa SELECT * FROM a WHERE ctid > '(1001, 0)'; We