X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C904B9DC80D for ; Tue, 21 Feb 2006 12:02:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95231-09 for ; Tue, 21 Feb 2006 12:02:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id ADCE69DC83D for ; Tue, 21 Feb 2006 12:02:48 -0400 (AST) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id k1LH6dOp007432; Tue, 21 Feb 2006 19:06:39 +0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id k1LH6dZ5007428; Tue, 21 Feb 2006 19:06:39 +0200 Date: Tue, 21 Feb 2006 19:06:39 +0200 (EET) From: Achilleus Mantzios To: Ibrahim Tekin cc: Stefan Schwarzer , Subject: Re: Avoid querying a specific field - how? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.11 required=5 tests=[AWL=0.110] X-Spam-Score: 0.11 X-Spam-Level: X-Archive-Number: 200602/256 X-Sequence-Number: 24266 O Ibrahim Tekin έγραψε στις Feb 21, 2006 : > i may i misunderstood your question but it seems to me, partial indexes will > work for you. > check this example: > http://www.postgresql.org/docs/8.1/interactive/indexes-partial.html#INDEXES-PARTIAL-EX2 > > On 2/21/06, Stefan Schwarzer wrote: > > > > Hi, > > > > does anyone know how to build a query that SELECTs all fields but not > > a specific one? I have a couple of tables, holding statistical > > information as well as the geospatial one (via Postgis). When I query > > the table I'd like to query only the statistical part - not the > > geospatial, which is not necessary and slows done incredibly the > > query. I searched a bit within the Postgres SQL domain. It seems > > there is an EXCEPT statement, but it seems that it works differently... Why dont you exclude the geospatial fields?? If * is a must then build a view. > > > > Thanks for any help, > > > > Stef > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > -- -Achilleus