Re: [PERFORM] Constraint propagating for equal fields

2010-02-01 Thread Віталій Тимчишин
30 січня 2010 р. 04:30 Greg Stark написав: > 2010/1/28 Віталій Тимчишин > > > > I've always thought that PostgreSQL would propagate constraint from > field1 to field2 if condition says field1=field2, but this does not seem the > case: > > version? > > PostgreSQL 8.3.7 on amd64-portbld-freebsd7.2

Re: [PERFORM] Constraint propagating for equal fields

2010-01-29 Thread Greg Stark
2010/1/28 Віталій Тимчишин > > I've always thought that PostgreSQL would propagate constraint from field1 to > field2 if condition says field1=field2, but this does not seem the case: version? -- greg -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make change

[PERFORM] Constraint propagating for equal fields

2010-01-28 Thread Віталій Тимчишин
Hello. I've always thought that PostgreSQL would propagate constraint from field1 to field2 if condition says field1=field2, but this does not seem the case: dict=# explain select * from domain_list,title.domains where processed_at is not null and key=groupid and key < 100 and groupid < 10