Re: check problem

On Fri, Feb 24, 2006 at 10:09:29 +0000,
Luis Silva <lfs12(at)hotmail(dot)com> wrote:
>
> is it possible to make a trigger that could evaluate all identities and
> search for the implicit_group that we want to insert and match with that
> private. if false return an error.

Why do you want such a function? What are you really trying to do?

It is usually better to ask about how you might accomplish a high level task
than to ask about how to use some particular solution to that task, as you
may not have picked a very good way to do things.

>
> >From: Bruno Wolff III <bruno(at)wolff(dot)to>
> >To: Luis Silva <lfs12(at)hotmail(dot)com>
> >CC: mike(at)fuhr(dot)org, pgsql-novice(at)postgresql(dot)org
> >Subject: Re: [NOVICE] check problem
> >Date: Thu, 23 Feb 2006 18:52:32 -0600
> >
> >On Thu, Feb 23, 2006 at 23:52:31 +0000,
> > Luis Silva <lfs12(at)hotmail(dot)com> wrote:
> >>
> >> tks for answering.
> >> Identity is the private key from the table. using your examples you
> >could
> >> have :
> >> 1) ident1,1,'aaaa'
> >> 2) ident2,1,'aaaa'
> >> 3) ident3,2,'aaaa'
> >> 4) ident4,3,'bbbb'
> >>
> >> but not
> >>
> >> 5)identi5,1,'bbbb'
> >>
> >> -->same implicit_group for different privates.
> >> is it possible? tks again
> >
> >The above table should only have the ident and the group number. The group
> >number should have a foreign key reference to another table of which the
> >group number is the primary key and another column for private.
> >This will allow only one private for each group number.
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 1: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
>
>