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

From Christian Enklaar
Subject Comparing a varchar of length > 32
Date
Msg-id civ5i0$12s4$1@news.hub.org
Whole thread Raw
Responses Re: Comparing a varchar of length > 32  (Peter Eisentraut <peter_e@gmx.net>)
Re: Comparing a varchar of length > 32  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-general
Hello,

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.

Does anybody know about this Problem ?
(We use PostgresQL 7.4.1)

Thanks in advance,
Christian Enklaar.





pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: mailing list archive search form broken?
Next
From: Peter Eisentraut
Date:
Subject: Re: Comparing a varchar of length > 32