On Thu, 2008-02-07 at 19:37 -0500, Robert Fitzpatrick wrote: > Been searching for a way to do this, but haven't found what I was hoping > to find. Is there any way in pl/pgsql to test a text value to see if it > would be a valid interval without having to try and store in a field? In > a trigger, I'd like to test a NEW text type field. Right now, I have > just the following to generate an error... > > test := NEW.textfield::interval; > > I'd like to test the field and RAISE EXCEPTION if not valid interval.
Trap the error and do what you want with it: http://www.postgresql.org/docs/8.3/static/plpgsql-control- structures.html#PLPGSQL-ERROR-TRAPPING Although: why do you want to generate your own error? It seems like it would probably be about the same as the error produced by the casting failure. Regards, Jeff Davis ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
