Re: Error handling in stored functions/procedures - Mailing list pgsql-general

From Jurgen Defurne
Subject Re: Error handling in stored functions/procedures
Date
Msg-id 20040530213835.77a51076.jurgen.defurne@pandora.be
Whole thread Raw
In response to Re: Error handling in stored functions/procedures  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: Error handling in stored functions/procedures
List pgsql-general
On Sun, 30 May 2004 20:04:50 +0200
Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:

> > a) The basic contents of the internal data dictionary can be used to
> > check incoming fields from on their length and permitted contents.
> >
> > b) With a little extra work, I should be able to define a table
> > which can be used to check field contents against field masks.
> You can use column check constraints with regular expressions
> for that. No need for an extra table I would assume.

Thanks for the tip.

This then, removes the first part of my explanation, and dumps me
completely in the second part, which is where the biggest problems
reside.

Jurgen

pgsql-general by date:

Previous
From: "John Wells"
Date:
Subject: Large table search question
Next
From: Karsten Hilbert
Date:
Subject: Re: Error handling in stored functions/procedures