Postgres Pro
Downloads
Home   >   mailing lists

Re: Constraint propagating for equal fields - Mailing list pgsql-performance

From Віталій Тимчишин
Subject Re: Constraint propagating for equal fields
Date
Msg-id 331e40661002010530u5c03068ek9878037344e23178@mail.gmail.com
Whole thread Raw
In response to Re: Constraint propagating for equal fields  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
Tree view


30 січня 2010 р. 04:30 Greg Stark <gsstark@mit.edu> написав:
2010/1/28 Віталій Тимчишин <tivv00@gmail.com>
>
> 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, compiled by GCC cc (GCC) 4.2.1 20070719  [FreeBSD] 

pgsql-performance by date:

Previous
From: Glenn Maynard
Date:
Subject: Slow query: table iteration (8.3)
Next
From: Yeb Havinga
Date:
Subject: Re: Slow query: table iteration (8.3)