Re: Comparing a varchar of length > 32 - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Comparing a varchar of length > 32
Date
Msg-id 200409232122.09643.peter_e@gmx.net
Whole thread Raw
In response to Comparing a varchar of length > 32  ("Christian Enklaar" <christian.enklaar@mbs-software.de>)
List pgsql-general
Christian Enklaar wrote:
> we are using a table with a primary key of type varchar[50].
> If we try to find entries with select * from <table> where
> <table.key> = '<text>';
> entries with a key length of more than 32 characters are not found.
> Entries with a shorter key are found. Using "Like" instead of "="
> works for varchar keys with length > 32 as well.

Please post the actual table definitions, the actual data, the actual
command you are running, and the actual results you are getting.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-general by date:

Previous
From: "Christian Enklaar"
Date:
Subject: Comparing a varchar of length > 32
Next
From: Gaetano Mendola
Date:
Subject: Re: Comparing a varchar of length > 32