Message-ID: <458438B9.5050103@poczta.fm>
Date: Sat, 16 Dec 2006 19:19:37 +0100
From: jamcito <jamcito@poczta.fm>
User-Agent: Thunderbird 1.5.0.8 (X11/20061203)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: partition text/varchar check problem -- solved
References: <458402D4.7080500@poczta.fm> <29283.1166284128@sss.pgh.pa.us>
In-Reply-To: <29283.1166284128@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Tom Lane wrote:
>> CREATE TABLE data_a (CHECK (name LIKE varchar 'a%')
>> ) INHERITS (data);
>> --
>> CREATE TABLE data_b (CHECK (name LIKE varchar 'b%')
>> ) INHERITS (data);
> 
> That's not going to work because the planner is unable to prove anything
> about the behavior of LIKE --- there is nothing in the system that
> offers a relationship between the = operator and the LIKE operator.
> You'll need something like
> 
> 	CHECK (name >= 'a' AND name < 'b')
> 	CHECK (name >= 'b' AND name < 'c')
> 
> etc.  (These work for a query like "WHERE name = 'foo'" because
> the >= < and = operators are all members of the same btree opclass,
> so the planner knows how to reason about them.)
> 
> 			regards, tom lane

Thank you, it works!

Cheers,
jamcito

----------------------------------------------------------------------
Jestes kierowca? To poczytaj! >>> http://link.interia.pl/f199e