Postgres Pro
Downloads
Home   >   mailing lists

Re: isnumeric - checking if text variable is convertable to numeric - Mailing list pgsql-general

From SunWuKung
Subject Re: isnumeric - checking if text variable is convertable to numeric
Date
Msg-id 1145955709.030685.51540@g10g2000cwb.googlegroups.com
Whole thread Raw
In response to Re: isnumeric - checking if text variable is convertable to numeric  ("Jaime Casanova" <systemguards@gmail.com>)
Responses Re: isnumeric - checking if text variable is convertable to numeric  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dumpall: does not exist database
Next
From: Rajarajan
Date:
Subject: Starting Postgresql as windows service