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




---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to