Re: isnumeric - checking if text variable is convertable to numeric

From: "SunWuKung" <Balazs(dot)Klein(at)t-online(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: isnumeric - checking if text variable is convertable to numeric
Date: 2006-04-25 09:01:49
Message-ID: 1145955709.030685.51540@g10g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I tried this but couldn't find out what would be the WHEN condition for

Select Cast('asdf' as numeric)
ERROR: invalid input syntax for type numeric

regards,
Balázs

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rajarajan 2006-04-25 09:03:57 Starting Postgresql as windows service
Previous Message Tom Lane 2006-04-25 07:46:34 Re: pg_dumpall: does not exist database