Postgres Pro
Downloads
Home   >   mailing lists

Re: Char to Int - Mailing list pgsql-general

From Rick Seeger
Subject Re: Char to Int
Date
Msg-id HKEPLMBPEGFGAKDKKAEDAEJGFKAA.rick@nettheory.com
Whole thread Raw
In response to Char to Int  ("Rick Seeger" <rick@nettheory.com>)
Responses Re: Char to Int  (Ron Johnson <ron.l.johnson@cox.net>)
Re: Char to Int  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 

-----Original Message-----

Oops, there was a typo in my second example. Still have the problem
tho...

> rs=#
> rs=# insert into table2
> rs=# select CAST(my_Id as integer)
>             ^^^^
> rs=# from table1;
> ERROR:  Cannot cast type character to integer
>

pgsql-general by date:

Previous
From: "Floyd Shackelford"
Date:
Subject: Table analyzer
Next
From: "Edwin Quijada"
Date:
Subject: Re: Virtual Machines and postgres