Re: sql row constructor...works!

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-hackers(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: sql row constructor...works!
Date: 2006-02-08 02:31:20
Message-ID: FD34053B-FC04-4920-BB60-F762C425F1F9@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Feb 8, 2006, at 11:17 , Merlin Moncure wrote:

> The proper SQL construct without row constructor is:
>
> select * from t where
> a >= a1 and
> (a > a1 or b>= b1) and
> (a > a1 or b > b1 or c > c1)
> order by a,b,c limit 1 ^ no offset necessary
>
> confused yet?

This is interesting! Could you also provide the equivalent *with* a
row constructor? (or did I miss that somewhere?)

Michael Glaesemann
grzm myrealbox com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2006-02-08 02:35:17 Re: sql row constructor...works!
Previous Message Merlin Moncure 2006-02-08 02:17:13 Re: sql row constructor...works!