|
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:jmartinez@xxxxxx 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
