Gregory Stark <stark@enterprisedb.com> writes:
> Havasv�lgyi Ott� <havasvolgyi.otto@gmail.com> writes:
>> I also tried Row constructors with a Between expression, but in this case
>> Postgres handled the elements of the row independently, and this led to
>> false query result.
> What version of Postgres is this? row constructors were fixed a long time ago
> to not do that and the main benefit of that was precisely that this type of
> expression could use a multi-column index effectively.
That depends on whether you think 8.2 is "a long time ago" ;-). But
yeah, row comparisons in a modern Postgres version are the way to handle
this.
regards, tom lane