From: Jan Wieck <JanWieck@Yahoo.com>
To: Achilleus Mantzios <achill@matrix.gatewaynet.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: Tue, 20 May 2003 10:57:53 -0400
Message-ID: <3ECA4271.4080400@Yahoo.com> (raw)
References: <Pine.LNX.4.44.0305161248550.10647-100000@matrix.gatewaynet.com>
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!
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
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
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: JanWieck@Yahoo.com, achill@matrix.gatewaynet.com, ch@rodos.fzk.de, rlucas@tercent.net
Subject: Re: Testing castability of text to numeric
In-Reply-To: <3ECA4271.4080400@Yahoo.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