Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id AAA81294 for ; Tue, 24 Aug 1999 00:29:58 -0400 (EDT) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id AAA16390; Tue, 24 Aug 1999 00:24:28 -0400 (EDT) From: Bruce Momjian Message-Id: <199908240424.AAA16390@candle.pha.pa.us> Subject: Re: [SQL] Expression with aggregate In-Reply-To: <19990823222823.28535.rocketmail@web804.mail.yahoo.com> from Scott Barron at "Aug 23, 1999 03:28:23 pm" To: Scott Barron Date: Tue, 24 Aug 1999 00:24:28 -0400 (EDT) CC: Albert REINER , PostgreSQL-SQL X-Mailer: ELM [version 2.4ME+ PL56 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > > That should provide the desired results. As for the > question about the view in the \d output, I don't know > why its like that, I've wondered myself. I think it is view? because it could be a view, or a rule? > > > > By the way, when I use \d to list the tables, why is > > a view always > > shown with a '?' like in > > > > asdf=> \d > > Database = asdf > > > > > +------------------+----------------------------------+----------+ > > | Owner | Relation > > | Type | > > > > > +------------------+----------------------------------+----------+ > > | albert | a > > | table | > > | albert | b > > | table | > > | albert | c > > | view? | > > > > > +------------------+----------------------------------+----------+ > > > > ? Why doesn't it just say '| albert | c | view |'? > > > > I'd really appreciate any hints with this, even > > though I know how to > > do it (as demonstrated above) with the use of the > > view. > > > > Thanks in advance for your help, > > > > Albert. > > > > -- > > > > > --------------------------------------------------------------------------- > > Post an / Mail to / Skribu al: Albert Reiner > > > > > --------------------------------------------------------------------------- > > > > ************ > > > > > > __________________________________________________ > Do You Yahoo!? > Bid and sell for free at http://auctions.yahoo.com > > > ************ > > -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026