From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Luis Sousa <llsousa(at)ualg(dot)pt> |
Cc: | pgsql sql Mailing List <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Hidden Select |
Date: | 2001-06-12 14:46:42 |
Message-ID: | Pine.LNX.4.30.0106121646270.756-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Luis Sousa writes:
> How's that ??
>
> How can i define the rule to do that ?
You just have to make the id column part of the view.
>
>
> Peter Eisentraut wrote:
>
> > Luis Sousa writes:
> >
> > > Suposing your example:
> > >
> > > Now i want to do a query to the view like this:
> > >
> > > SELECT * FROM C WHERE id=1;
> > >
> > > I whant to chose the id, but that id isn't in my select list !!!?????
> >
> > Then you will have to define your view differently.
> >
> > > > Do you mean like this?
> > > >
> > > > create table A (id int, content text);
> > > > create table B (id int, stuff numeric);
> > > > create view C as select A.content, B.stuff from A, B where A.id = B.id;
> >
> > --
> > Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
From | Date | Subject | |
---|---|---|---|
Next Message | Martín Marqués | 2001-06-12 15:17:13 | Re: tables, permissions, sequences |
Previous Message | Alla | 2001-06-12 14:32:37 | Please help! Functions passing records between them |