Re: Hidden Select

How's that ??

How can i define the rule to do that ?


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@gmx.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@postgresql.org)