Bruno Wolff III wrote:
> How about something like the following:
> select * from t
> where a >= a1 and b >= b1
>order by a, b limit 1 offset 1;
Well, this may have recently changed, but the offset clause is not
suitable for arbitrary jumps over large tables. Essentially, pg does an
i
On Fri, Aug 15, 2003 at 13:42:23 -0400,
Merlin Moncure <[EMAIL PROTECTED]> wrote:
>
> Example:
> I have a table t with columns a, b, c. I have values a1, b1, c1 for
> those columns and would like to know the next value in the table when
> ordered by a, b. I have values a1, b1, and oid1 and w
