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

Re: check problem

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: check problem
Date: 2006-02-24 14:38:50
Message-ID: 20060224143850.GA24287@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
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
> 
> 

In response to

Responses

pgsql-novice by date

Next:From: Richard KutDate: 2006-02-24 14:57:06
Subject: Transaction Questions
Previous:From: A. KretschmerDate: 2006-02-24 10:37:11
Subject: Re: View running Processes ?

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