MS SQL "isDate" equivalent in plpgsql? - Mailing list pgsql-general

From Daniel Gehrke
Subject MS SQL "isDate" equivalent in plpgsql?
Date
Msg-id 5gc0ab.bss.ln@igate28.intern.neusta.de
Whole thread Raw
Responses Re: MS SQL "isDate" equivalent in plpgsql?  (Joe Conway <mail@joeconway.com>)
List pgsql-general
Hi,

I am not sure if this is the right newsgroup. If not, please excuse, I
didn't find one, that'ld fit better. *g*

I am porting from MS SQL 7.0 to PostgreSQL. In one Stored Procedure the
function "isDate" is used. IsDate determines, whether the input string is a
date or not:

select isdate('05.15.2003');
Result: 1
select isdate('foobar');
Result: 0

Is there a function in plpgsql like that?
Maybe someone has a self-written function that implements that?

Thanks in advance and regards,
Daniel



pgsql-general by date:

Previous
From: Tapan Trivedi
Date:
Subject: Query changes
Next
From: "SABOURIN Thomas"
Date:
Subject: