Re: Error handling in stored functions/procedures

From: Jurgen Defurne <jurgen(dot)defurne(at)pandora(dot)be>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error handling in stored functions/procedures
Date: 2004-05-30 19:38:35
Message-ID: 20040530213835.77a51076.jurgen.defurne@pandora.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 30 May 2004 20:04:50 +0200
Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2004-05-30 20:08:10 Re: Error handling in stored functions/procedures
Previous Message Karsten Hilbert 2004-05-30 18:04:50 Re: Error handling in stored functions/procedures