Re: Comparing a varchar of length > 32

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Christian Enklaar" <christian(dot)enklaar(at)mbs-software(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: Comparing a varchar of length > 32
Date: 2004-09-23 19:22:09
Message-ID: 200409232122.09643.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2004-09-23 20:24:17 need "row number"
Previous Message Gaetano Mendola 2004-09-23 19:15:38 Re: Comparing a varchar of length > 32