Re: text & char(32)

If your define your table using varchar(32), instead of char(32), your
query will work fine.

--
banghe

Herbert Ambos wrote:

> On Tue, 19 Sep 2000, Vladimir V. Zolotych wrote:
>
> > Hi all,
> > Can you help me a bit ?
> > The question is: how can I compare TEXT and CHAR(32) types ?
> > More detailed description:
> > my=> create table foo (tt text, cc char(32));
> >
> > CREATE
> > my=> insert into foo values ('aa', 'ab');
> >
> > INSERT 27476810 1
> > my=> insert into foo values ('aa', 'aa');
> >
> > INSERT 27476811 1
> > my=> select * from foo where tt=cc;
> >
> > tt|cc
> > --+--
> > (0 rows)
> > So the operator '=' doesn't work as I expected.
> > Any help will be appreciated.
> >
> >
>
> try
>
> select * from foo where tt=trim(cc);
>
> herbert