Comparing a varchar of length > 32

From: "Christian Enklaar" <christian(dot)enklaar(at)mbs-software(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Comparing a varchar of length > 32
Date: 2004-09-23 18:45:32
Message-ID: civ5i0$12s4$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2004-09-23 19:15:38 Re: Comparing a varchar of length > 32
Previous Message Greg Stark 2004-09-23 17:05:21 Re: mailing list archive search form broken?