Gregory Stark <[email protected]> writes:
> Havasvölgyi Ottó <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
