<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
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.<br>
<br>
Matt Doughty schreef:
<blockquote
cite="mid:8A38B86D9187B34FA18766E261AB3AEA0D205C@sageograma.GEO-I.local"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EstiloCorreo17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Hi,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;" lang="EN-GB">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.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;" lang="EN-GB"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;" lang="EN-GB">Cheers,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;" lang="EN-GB"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;" lang="EN-GB">Matt<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;" lang="EN-GB"><o:p> </o:p></span></font></p>
<table class="MsoNormalTable"
style="background: white none repeat scroll 0%; width: 100%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"
align="left" bgcolor="white" border="0" cellpadding="0" width="100%">
<tbody>
<tr>
<td colspan="2" style="padding: 0.75pt;">
<p class="MsoNormal" style=""><font face="Times New Roman"
size="3"><span style="font-size: 12pt;" lang="EN-GB"> <o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 0.75pt;">
<p class="MsoNormal" style=""><font face="Times New Roman"
size="3"><span style="font-size: 12pt;" lang="EN-GB"> <o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style="padding: 0.75pt;">
<p class="MsoNormal" style=""><font color="#2e3a75" face="Arial"
size="3"><span
style="font-size: 12pt; font-family: Arial; color: rgb(46, 58, 117);">Matt
Doughty</span></font><o:p></o:p></p>
</td>
<td rowspan="5" style="padding: 0.75pt;" valign="top">
<p class="MsoNormal" style=""><font face="Times New Roman"
size="3"><span style="font-size: 12pt;"><img id="_x0000_i1025"
src="cid:part1.09050806.09030608@zeelandnet.nl" height="100" width="90"><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style="padding: 0.75pt;">
<p class="MsoNormal" style=""><font color="#2e3a75" face="Arial"
size="3"><span
style="font-size: 12pt; font-family: Arial; color: rgb(46, 58, 117);">GEOGRAMA
S.L.</span></font><font face="Arial"><span style="font-family: Arial;"><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style="padding: 0.75pt;">
<p class="MsoNormal" style=""><font color="#2e3a75" face="Arial"
size="3"><span
style="font-size: 12pt; font-family: Arial; color: rgb(46, 58, 117);">Tel.:
+34 945 13 13 72 652 77 14 15</span></font><font face="Arial"><span
style="font-family: Arial;"><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style="padding: 0.75pt;">
<p class="MsoNormal" style=""><font color="#2e3a75" face="Arial"
size="3"><span
style="font-size: 12pt; font-family: Arial; color: rgb(46, 58, 117);">Fax:
+34 945 23 03 40 </span></font><font face="Arial"><span
style="font-family: Arial;"><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style="padding: 0.75pt;">
<p class="MsoNormal" style=""><font color="#2e3a75" face="Arial"
size="3"><span
style="font-size: 12pt; font-family: Arial; color: rgb(46, 58, 117);"><a class="moz-txt-link-abbreviated" href="http://www.geograma.com">www.geograma.com</a></span></font><font
face="Arial"><span style="font-family: Arial;"><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 0.75pt;">
<p class="MsoNormal" style=""><font face="Times New Roman"
size="3"><span style="font-size: 12pt;"> <o:p></o:p></span></font></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size: 12pt;"><o:p> </o:p></span></font></p>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 5px;
margin-top: 5px;
margin-right: 5px;
margin-bottom: 5px;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
</td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p class="style4">Milo van der Linden
<br>
<a href="skype:milovanderlinden?add">skype: milovanderlinden</a><br>
<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
<a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
<a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
<a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
</p>
</td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p class="style5"><span lang="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.</span>
<span lang="EN">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.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>