X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 1EA4D9256F4 for ; Mon, 19 May 2003 18:00:40 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 31050-04 for ; Mon, 19 May 2003 18:00:35 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by developer.postgresql.org (Postfix) with ESMTP id 4F024925624 for ; Mon, 19 May 2003 05:19:30 -0400 (EDT) Received: from matrix.gatewaynet.com (localhost [127.0.0.1]) by matrix.gatewaynet.com (8.12.5/8.12.5) with ESMTP id h4JEMkEn007834; Mon, 19 May 2003 12:22:48 -0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.5/8.12.5/Submit) with ESMTP id h4GEvok5011332; Fri, 16 May 2003 12:57:50 -0200 Date: Fri, 16 May 2003 12:57:50 -0200 (GMT+2) From: Achilleus Mantzios To: Christoph Haller Cc: pgsql-sql@postgresql.org, Subject: Re: Testing castability of text to numeric In-Reply-To: <3EC4B2BA.B872FCDF@rodos.fzk.de> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/366 X-Sequence-Number: 13531 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