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)
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 |
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... |