Gregory Stark <st...@enterprisedb.com> writes:
> Havasvölgyi Ottó <havasvolgyi.o...@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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
