varchar of length > 32

From: "Christian Enklaar" <christian(dot)enklaar(at)mbs-software(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: varchar of length > 32
Date: 2004-09-23 10:56:06
Message-ID: ciua1q$1vbk$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message frederic.germaneau 2004-09-23 11:45:44 v8 on AIX5.2
Previous Message Anish Kumar K. 2004-09-23 07:45:26 How to retreive rowid