[postgis-users] Except

[Milo van der Linden]

This is not going to work, there is no except function in sql, you will 
need to write out the statement completely. This is also no postGIS issue.

Matt Doughty schreef:
>
> 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
>
>  
>
>  
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   


-- 


	

Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
mlinden at zeelandnet.nl <mailto:mlinden at zeelandnet.nl>
milovanderlinden at gmail.com <mailto:milovanderlinden at gmail.com>
milo at 3dsite.nl <mailto:milo at 3dsite.nl>
http://www.3dsite.nl

	  	

De informatie in dit bericht reflecteert mijn persoonlijke mening en 
niet die van een bedrijf of instantie. Aan de informatie kunnen geen 
rechten worden ontleend. Indien dit bericht onderdeel is van een forum, 
mailing-list of community dan gelden automatisch de bij het betreffende 
medium behorende voorwaarden. The information in this message reflects 
my personal opinion and not that of a company or public body. All rights 
reserved.If this message is contained in a mailing-list or community, 
the rights on the medium are automatically adapted.

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