Message-ID: <3ECA4271.4080400@Yahoo.com>
Date: Tue, 20 May 2003 10:57:53 -0400
From: Jan Wieck <JanWieck@Yahoo.com>
Organization: Unorganized
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.0.2) Gecko/20030208 Netscape/7.02
MIME-Version: 1.0
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: Christoph Haller <ch@rodos.fzk.de>, pgsql-sql@postgresql.org,
	rlucas@tercent.net
Subject: Re: Testing castability of text to numeric
References: <Pine.LNX.4.44.0305161248550.10647-100000@matrix.gatewaynet.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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 #