Gregory Stark <stark@xxxxxxxxxxxxxxxx> writes: > Havasvölgyi Ottó <havasvolgyi.otto@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
