Date type in pl/pgsql function checking passed parameter
am 24.10.2005 15:02:10 von Majolee InfoTechThis is a multi-part message in MIME format.
------=_NextPart_000_009D_01C5D8C9.3EDB9050
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello All,
We have a pl/pgsql function functionName(date) .. here if it has been =
called using functionName('23456') it gives error .. we need to raise an =
exception(customized error message) if the passed value is not date.. =
how can we do that.
Thanks..
------=_NextPart_000_009D_01C5D8C9.3EDB9050
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
12:00:00 GMT">
charset=3Diso-8859-1">
Hello All,
We have a pl/pgsql function =
functionName(date) ..=20
here if it has been called using functionName('23456') it gives error .. =
we need=20
to raise an exception(customized error message) if the passed value is =
not=20
date.. how can we do that.
functionName(date) ..=20
here if it has been called using functionName('23456') it gives error .. =
we need=20
to raise an exception(customized error message) if the passed value is =
not=20
date.. how can we do that.
Thanks..
href=3D"http://165845.sigclick.mailinfo.com/sigclick/0104050 9/00024E00/05=
4E0220201472.jpg">
/054E0220201472.jpg" border=3D"0" nosend=3D"1">
style=3D"font-family=3DVerdana;font-size=3D11px;">Make sure YOUR emails =
don't get lost! Download Mailinfo here =
=00
------=_NextPart_000_009D_01C5D8C9.3EDB9050--