Re: sql row constructor...works!

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: sql row constructor...works!
Date: 2006-02-08 00:04:32
Message-ID: m3vevq3ecv.fsf@mobile.int.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> It's esoteric enough that I don't know what you're talking about. Can
>> you give us an example?
>
> He's talking about this:
> http://archives.postgresql.org/pgsql-performance/2004-07/msg00188.php

Hmm...

So the example would be that if you have just read a record from t
that gave you value t.a=a1, t.b=b1, t.c=c1, the next one, based on
a,b,c, would be...

select * from t where a >= a1 and b >= b1 and c >= c1
order by a,b,c
limit 1 offset 1;

Right?
--
output = ("cbbrowne" "@" "gmail.com")
http://linuxdatabases.info/info/lsf.html
"It's not about 'Where do you want to go today?'"; "It's more like,
'Where am I allowed to go today?'"

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2006-02-08 00:49:02 Re: streamlined standby procedure
Previous Message Rodolfo Campos 2006-02-07 23:45:58 Problems compiling a trigger