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.
>From: Bruno Wolff III <bruno@wolff.to>
>To: Luis Silva <lfs12@hotmail.com>
>CC: mike@fuhr.org, pgsql-novice@postgresql.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@hotmail.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@postgresql.org so that your
> message can get through to the mailing list cleanly