[GENERAL] Comparing a varchar of length 32

2004-09-23 Thread Christian Enklaar
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

Re: [GENERAL] Comparing a varchar of length 32

2004-09-23 Thread Peter Eisentraut
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 =

Re: [GENERAL] Comparing a varchar of length 32

2004-09-23 Thread Gaetano Mendola
Christian Enklaar wrote: 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