Re: Hidden Select
От | Peter Eisentraut |
---|---|
Тема | Re: Hidden Select |
Дата | |
Msg-id | Pine.LNX.4.30.0106121646270.756-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: Hidden Select (Luis Sousa <llsousa@ualg.pt>) |
Список | 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@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) > > -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
В списке pgsql-sql по дате отправления: