From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Jan Wieck <JanWieck@Yahoo.com>
Cc: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-sql@postgresql.org
Cc: rlucas@tercent.net
Subject: Re: Testing castability of text to numeric
Date: Wed, 21 May 2003 11:55:37 -0200 (GMT+2)
Message-ID: <Pine.LNX.4.44.0305211153030.18772-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <3ECA4271.4080400@Yahoo.com>
On Tue, 20 May 2003, Jan Wieck wrote:
> Achilleus Mantzios wrote:
> > 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!
I would say, why offload such tasks (the fellow pgsql'er
talked about casting exceptions) to postgresql
when you can do that better in the client side language.
>
> It doesn't matter how exceptional Java's exception handling is.
> PostgreSQL's exception handling is just like a black hole - once the
> gravity got it, you won't get your transaction back ever.
>
> The current effort on subtransactions might change that. But I'm not
> sure what performance impact or other side effects it will have to
> execute every single statement inside of a stored procedure as a
> separate subtransaction just to have catchable exceptions.
>
>
> Jan
>
>
--
==================================================================
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, JanWieck@Yahoo.com, ch@rodos.fzk.de, rlucas@tercent.net
Subject: Re: Testing castability of text to numeric
In-Reply-To: <Pine.LNX.4.44.0305211153030.18772-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