Avoid querying a specific field - how?

Поиск
Список
Период
Сортировка
От Stefan Schwarzer
Тема Avoid querying a specific field - how?
Дата
Msg-id CCBD2F24-D958-4504-BB00-5757910D5AED@grid.unep.ch
обсуждение исходный текст
Ответы Re: Avoid querying a specific field - how?  ("Ibrahim Tekin" <itekin@gmail.com>)
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: ORDER BY with LTREE
Следующее
От: "Ibrahim Tekin"
Дата:
Сообщение: Re: Avoid querying a specific field - how?