[HACKERS] string cast/compare broken?

2002-07-11 Thread Scott Royston
Mac OS X: postgres% psql --version psql (PostgreSQL) 7.2.1 contains support for: multibyte LEDEV=# create table test1 (foo varchar(5)); CREATE LEDEV=# create table test2 (foo char(5)); CREATE LEDEV=# insert into test2 (foo) values ('S'); INSERT 3724249 1 LEDEV=# insert into test1 (foo) values ('S

Re: [HACKERS] [SQL] can't cast varchar as integer?

2002-05-14 Thread Scott Royston
2002-05-14 at 13:56, Scott Royston wrote: >> Mac OSX, postgresql 7.2.1 >> >> what's the reasoning behind not being able to cast a varchar as >> integer? this seems very weird to me: >> >> LEDEV=# create table test (foo varchar(5), bar text); >>