From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-sql@postgresql.org, <rlucas@tercent.net>
Subject: Re: Testing castability of text to numeric
Date: Fri, 16 May 2003 12:57:50 -0200 (GMT+2)
Message-ID: <Pine.LNX.4.44.0305161248550.10647-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <3EC4B2BA.B872FCDF@rodos.fzk.de>
On Fri, 16 May 2003, Christoph Haller wrote:
> >
> > I am trying to create a function that will test if a given text value
> > may safely be cast to numeric, returning the numeric cast or null if
> > impossible.
I think that progress is being made on
having java as a serverside language
(i.e. plpgjava).
Stored procedures in java would be really handy in order
to do staff like that, java is known for its
"exceptional" exception handling!
What language do you use to bould your applications??
> >
> > Is there a way to "catch" the "ERROR: Bad numeric input format"
> error?
> >
> > I ask that rather than about what the numeric format is for
> regex-style
> > testing because if this works I may want to use a similar method to
> > check if a given text value casts safely to other types, like date.
> >
> I don't know of any way to catch errors.
> And I can't see any way how to test castability via regex. Can you?
> The only way I can think of at the moment is writing a C function.
>
> Regards, Christoph
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, ch@rodos.fzk.de, rlucas@tercent.net
Subject: Re: Testing castability of text to numeric
In-Reply-To: <Pine.LNX.4.44.0305161248550.10647-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox