[postgis-users] Except

[Gerrit]

Hi Matt

 

I don't know of 1 but you can say Select field1, field2 etc.

 

I know you can select distinct on various fields

 

Will checkup and if there 1 ill email you

 

Cheers

 

Gerrit de Villiers

 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Matt
Doughty
Sent: 28 November 2007 02:31 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Except

 

Hi,

 

Is there a way of selecting all fields except one in particular? I'd like to
create a query that says something like: select * except field01.  The thing
is the query needs to be valid for a number of different tables, each with a
different set of fields apart from one (gid), which I don't want to select.

 

Cheers,

 

Matt

 


 


 


Matt Doughty




GEOGRAMA S.L.


Tel.:  +34 945 13 13 72    652 77 14 15


Fax: +34 945 23 03 40 


www.geograma.com


 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071128/56005094/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3743 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071128/56005094/attachment.jpg>