| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Michael Glaesemann <grzm(at)myrealbox(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:35:17 |
| Message-ID: | b42b73150602071835m172755fcmf3592e60f59db12d@mail.gmail.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?)
select * from t where (a,b,c) > (a1, b1, c1) order by a,b,c limit 1;
[plus full usage of key on t(a,b,c)]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2006-02-08 02:47:41 | Re: sql row constructor...works! |
| Previous Message | Michael Glaesemann | 2006-02-08 02:31:20 | Re: sql row constructor...works! |