pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedAvoid querying a specific field - how?
3+ messages / 3 participants
[nested] [flat]
* Avoid querying a specific field - how?
@ 2006-02-21 11:55 Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
2006-02-21 15:32 ` Re: Avoid querying a specific field - how? Ibrahim Tekin <itekin@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Stefan Schwarzer @ 2006-02-21 11:55 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Avoid querying a specific field - how?
2006-02-21 11:55 Avoid querying a specific field - how? Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
@ 2006-02-21 15:32 ` Ibrahim Tekin <itekin@gmail.com>
2006-02-21 17:06 ` Re: Avoid querying a specific field - how? Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 3+ messages in thread
From: Ibrahim Tekin @ 2006-02-21 15:32 UTC (permalink / raw)
To: Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>; +Cc: pgsql-sql
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 <stefan.schwarzer@grid.unep.ch> 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...
>
> 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Avoid querying a specific field - how?
2006-02-21 11:55 Avoid querying a specific field - how? Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
2006-02-21 15:32 ` Re: Avoid querying a specific field - how? Ibrahim Tekin <itekin@gmail.com>
@ 2006-02-21 17:06 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 3+ messages in thread
From: Achilleus Mantzios @ 2006-02-21 17:06 UTC (permalink / raw)
To: Ibrahim Tekin <itekin@gmail.com>; +Cc: Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>; pgsql-sql
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 <stefan.schwarzer@grid.unep.ch> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-02-21 17:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-21 11:55 Avoid querying a specific field - how? Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
2006-02-21 15:32 ` Ibrahim Tekin <itekin@gmail.com>
2006-02-21 17:06 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox