Re: Constraint propagating for equal fields

From: Віталій Тимчишин <tivv00(at)gmail(dot)com>
To:
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Constraint propagating for equal fields
Date: 2010-02-01 13:30:57
Message-ID: 331e40661002010530u5c03068ek9878037344e23178@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

30 січня 2010 р. 04:30 Greg Stark <gsstark(at)mit(dot)edu> написав:

> 2010/1/28 Віталій Тимчишин <tivv00(at)gmail(dot)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]

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Yeb Havinga 2010-02-01 14:54:47 Re: Slow query: table iteration (8.3)
Previous Message Glenn Maynard 2010-01-30 03:49:46 Slow query: table iteration (8.3)