Received: from mozart.si.ualg.pt (mozart.si.ualg.pt [193.136.224.2]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5C8RQE73409 for ; Tue, 12 Jun 2001 04:27:26 -0400 (EDT) (envelope-from llsousa@ualg.pt) Received: from ualg.pt (llsousa@corisco.uceh.ualg.pt [10.10.20.126]) by mozart.si.ualg.pt (8.9.1/8.9.1) with ESMTP id JAA514569; Tue, 12 Jun 2001 09:27:20 +0100 (WEST) Message-ID: <3B25D267.E7967A6E@ualg.pt> Date: Tue, 12 Jun 2001 09:27:19 +0100 From: Luis Sousa Organization: Universidade do Algarve X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-compact i686) X-Accept-Language: en, pt MIME-Version: 1.0 To: Peter Eisentraut CC: pgsql sql Mailing List Subject: Re: Hidden Select References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/172 X-Sequence-Number: 3395 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)