Re: type casting varchar to int - Mailing list pgsql-general

From Stephan Szabo
Subject Re: type casting varchar to int
Date
Msg-id Pine.BSF.4.10.10009080840270.98168-100000@megazone23.bigpanda.com
Whole thread Raw
In response to type casting varchar to int  (Hoosain Madhi <MADHIH@vodacom.co.za>)
List pgsql-general
You can make an intermediate step through text
<colume>::text::int

However, it'll fail if there are any values it cannot
turn into an integer (with an elog) which may not
be what you want.

Stephan Szabo
sszabo@bigpanda.com

On Fri, 8 Sep 2000, Hoosain Madhi wrote:

> Is it possible to type cast from varchar to int? Postgres backend complains
> when I try to do this.


pgsql-general by date:

Previous
From: Gilles DAROLD
Date:
Subject: Re: Perl Module + postgres 7.0.2
Next
From: Stephan Szabo
Date:
Subject: Re: SERIAL type in RULES