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. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
