Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: isnumeric - checking if text variable is convertable to numeric
From: "SunWuKung" <Balazs.Klein@xxxxxxxxxxx>
Date: 25 Apr 2006 02:01:49 -0700
Complaints-to: groups-abuse@xxxxxxxxxx
In-reply-to: <c2d9e70e0604242116j49bd4c8crde68026d1f83015e@xxxxxxxxxxxxxx>
Injection-info: g10g2000cwb.googlegroups.com; posting-host=81.182.182.84; posting-account=JdIaAA0AAADPXHV9mtA2D1VeDzRZR32X
Organization: http://groups.google.com
References: <1145881906.855705.70740@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> <20060424175507.GB2747@xxxxxxxxx> <1145908191.828345.121440@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> <c2d9e70e0604242116j49bd4c8crde68026d1f83015e@xxxxxxxxxxxxxx>
User-agent: G2/0.2

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: isnumeric - checking if text variable is convertable to numeric
  - From: A. Kretschmer

References:
- isnumeric - checking if text variable is convertable to numeric
  - From: SunWuKung
- Re: isnumeric - checking if text variable is convertable to numeric
  - From: Martijn van Oosterhout
- Re: isnumeric - checking if text variable is convertable to numeric
  - From: SunWuKung
- Re: isnumeric - checking if text variable is convertable to numeric
  - From: Jaime Casanova

Prev by Date: Re: pg_dumpall: does not exist database
Next by Date: Starting Postgresql as windows service
Previous by thread: Re: isnumeric - checking if text variable is convertable to numeric
Next by thread: Re: isnumeric - checking if text variable is convertable to numeric
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]