non fatal casting?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: non fatal casting?
Date: 2001-09-16 08:07:40
Message-ID: 20010916100740.2c349142.depesz@depesz.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi
is there any way to make non-fatal casts (text -=> date and so on?)
it would be just perfect if i could do something like:
try:
my_date := my_text::date;
except:
return -1;
end:
return 0;

i'd like to use it in plpgsql functions. anyway to do it?

depesz

--
hubert depesz lubaczewski http://www.depesz.pl/
------------------------------------------------------------------------
... vows are spoken to be broken ... [enjoy the silence]
... words are meaningless and forgettable ... [depeche mode]

Browse pgsql-general by date

  From Date Subject
Next Message Arne Weiner 2001-09-16 10:01:53 Re: adding a superuser
Previous Message Ken Conrad 2001-09-16 06:01:50 Characters displaying as x2F