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

Re: check problem

From: "Luis Silva" <lfs12(at)hotmail(dot)com>
To: bruno(at)wolff(dot)to
Cc: mike(at)fuhr(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: check problem
Date: 2006-02-24 10:09:29
Message-ID: BAY18-F3354D4C91484CDBB7AB81B5F30@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-novice
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(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



In response to

Responses

pgsql-novice by date

Next:From: Arnaud LesauvageDate: 2006-02-24 10:24:43
Subject: Re: View running Processes ?
Previous:From: A. KretschmerDate: 2006-02-24 10:05:17
Subject: Re: View running Processes ?

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