Hello everybody,
I'm Jordi from Spain, I'm new on this mailing list. I hope I could help
anybody in the future but now I new some help because I read a lot of
documentation but I can't find an answer.
I have two questions:
--------------------------------------------------------------------------------------------------
*1.- Exception throwed by cast('yyyymmdd' as timestamp)
I do a cast conversion from a string to a timestamp*. When I put a bad
date on the string, the cast throw an error on my PL/PGSQL but I can't
capture (I'm new). *Which type of exception launch the cast function?*
I put a exception space on my function but I don't know which exception
I have ti capture:
EXCEPTION
WHEN exception_name THEN
statements;
Which exception _name I have to write on my code?
--------------------------------------------------------------------------------------------------
*2.- Number of days on February*
I'm parsing a string with a date with format 'yyyymmdd' for testing if
it's a valid date.
I need to know if the day is correct for the month on the string, but
February is different for every year. How can I know if February have 28
or 29 days depending on the year?
Thanks everybody and hello from a new user ;-)
begin:vcard
fn;quoted-printable:Jordi Mart=C3=ADnez
n;quoted-printable:Mart=C3=ADnez;Jordi
org;quoted-printable:Universitat Internacional de Catalunya;Servei d'inform=C3=A0tica
adr;quoted-printable:;;Carrer de la Inmaculada, 22;Barcelona;;08017;Espa=C3=B1a
email;internet:jmarti...@uic.es
tel;work:(+34) 932 541 800 Ext. 4410
url:www.uic.es
version:2.1
end:vcard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
