Re: Testing castability of text to numeric

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