[SQL] Avoid querying a specific field - how?
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... Thanks for any help, Stef ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [SQL] Avoid querying a specific field - how?
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 <[EMAIL PROTECTED]> wrote: Hi,does anyone know how to build a query that SELECTs all fields but nota specific one? I have a couple of tables, holding statisticalinformation as well as the geospatial one (via Postgis). When I query the table I'd like to query only the statistical part - not thegeospatial, which is not necessary and slows done incredibly thequery. I searched a bit within the Postgres SQL domain. It seemsthere is an EXCEPT statement, but it seems that it works differently... Thanks for any help,Stef---(end of broadcast)---TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [SQL] Avoid querying a specific field - how?
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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your > >message can get through to the mailing list cleanly > > > -- -Achilleus ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
