Re: sql row constructor...works! - Mailing list pgsql-hackers

From Michael Glaesemann
Subject Re: sql row constructor...works!
Date
Msg-id FD34053B-FC04-4920-BB60-F762C425F1F9@myrealbox.com
Whole thread Raw
In response to Re: sql row constructor...works!  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: sql row constructor...works!
List 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





pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: sql row constructor...works!
Next
From: Merlin Moncure
Date:
Subject: Re: sql row constructor...works!