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.
--
Best regards,
Vladimir mailto:gsmith(at)eurocom(dot)od(dot)ua