From: | Randall Lucas <rlucas(at)tercent(dot)net> |
---|---|
To: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
Cc: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Testing castability of text to numeric |
Date: | 2003-05-21 18:55:17 |
Message-ID: | C3B949D4-8BBD-11D7-8176-000A957653D6@tercent.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi Folks,
I thought that I would point out that an answer that answers my
original query (how to test for castability without throwing exception)
was posted to the pgsql-general list on Sunday, by Joe Conway. He has
an "str_validate" set of functions which he makes available at
joeconway.com. Thanks to Joe.
Best,
Randall
On Friday, May 16, 2003, at 10:57 AM, 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!
>
> 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(at)matrix(dot)gatewaynet(dot)com
> mantzios(at)softlab(dot)ece(dot)ntua(dot)gr
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-05-22 02:45:44 | Re: function prepared plan |
Previous Message | Eric Anderson Vianet SAO | 2003-05-21 16:49:18 | see toast table |