can't cast varchar as integer?

From: Scott Royston <scroyston(at)mac(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: can't cast varchar as integer?
Date: 2002-05-14 18:56:33
Message-ID: 4EE21904-676C-11D6-BF4D-000393577144@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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 as varchar(5), bar as text);
ERROR: parser: parse error at or near "as"
LEDEV=# create table test (foo varchar(5), bar text);
CREATE
LEDEV=# insert into test (foo, bar) values ('123', '123');
INSERT 409490 1
LEDEV=# select * from test;
foo | bar
-----+-----
123 | 123
(1 row)

LEDEV=# select cast(foo as integer) from test;
ERROR: Cannot cast type 'character varying' to 'integer'
LEDEV=# select cast(bar as integer) from test;
bar
-----
123
(1 row)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2002-05-14 19:27:51 7.2.2 ?
Previous Message mlw 2002-05-14 17:55:19 Re: Global Variables (Was: Re: Discontent with development

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-05-14 20:13:17 Re: aggregate...
Previous Message Mathieu Arnold 2002-05-14 16:13:09 aggregate...