From: | "Joel Burton" <joel(at)joelburton(dot)com> |
---|---|
To: | "Scott Royston" <scroyston(at)mac(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: can't cast varchar as integer? |
Date: | 2002-05-14 21:20:20 |
Message-ID: | JGEPJNMCKODMDHGOBKDNIEEICOAA.joel@joelburton.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
> what's the reasoning behind not being able to cast a varchar as
> integer? this seems very weird to me:
>
> 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)
Interesting. You can have an intermediate to-text cast:
select cast ( cast ( cast ('123' as varchar) as text) as integer);
From | Date | Subject | |
---|---|---|---|
Next Message | David Stanaway | 2002-05-14 21:47:39 | Re: can't cast varchar as integer? |
Previous Message | Oleg Bartunov | 2002-05-14 19:27:51 | 7.2.2 ? |
From | Date | Subject | |
---|---|---|---|
Next Message | David Stanaway | 2002-05-14 21:47:39 | Re: can't cast varchar as integer? |
Previous Message | Thomas Good | 2002-05-14 20:50:20 | CHECK CONSTRAINT blunder(s) |