Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group