Re: Char to Int

From: "Rick Seeger" <rick(at)nettheory(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Char to Int
Date: 2003-10-14 21:11:47
Message-ID: HKEPLMBPEGFGAKDKKAEDAEJGFKAA.rick@nettheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-10-14 21:18:19 Re: How to list which tables are available?
Previous Message Floyd Shackelford 2003-10-14 21:11:08 Table analyzer