Re: [SQL] Avoid querying a specific field - how?

2006-02-21 Thread Achilleus Mantzios
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 PROTEC

Re: [SQL] Avoid querying a specific field - how?

2006-02-21 Thread Ibrahim Tekin
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

[SQL] Avoid querying a specific field - how?

2006-02-21 Thread Stefan Schwarzer
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