<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16640" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=198405700-05052008>Well geometry is the superclass of all geometry type
objects as defined in the OpenGIS Consortium (OGC) specs that PostGIS,
DB2, Oracle and upcoming SQL Server 2008 follow. This part of
the PostGIS manual describes it a bit</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=198405700-05052008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=198405700-05052008><A
href="http://postgis.refractions.net/docs/ch04.html#id2681045">http://postgis.refractions.net/docs/ch04.html#id2681045</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=198405700-05052008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=198405700-05052008>This pdf has a nice hierarchy diagram of how the
various geometry types are conceptually related</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=198405700-05052008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=198405700-05052008><A
href="http://doesen0.informatik.uni-leipzig.de/proceedings/paper/68.pdf">http://doesen0.informatik.uni-leipzig.de/proceedings/paper/68.pdf</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=198405700-05052008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=198405700-05052008></SPAN></FONT> </DIV>
<DIV><SPAN class=198405700-05052008></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>Geometry set is a <SPAN
class=198405700-05052008>compound
</SPAN>term that is a combination of PostGIS and PostgreSQL terminology.</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT
size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT face=Arial><FONT color=#0000ff><FONT size=2>B<SPAN
class=198405700-05052008>asically PostgreSQL has functions that can take and
output SETOF some class of objects. So SETOF geometry is a geometry
set.</SPAN></FONT></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=198405700-05052008></SPAN></FONT></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=198405700-05052008>SETOF is basically an array of instances of a
particular class of objects. This is different from the OGC term
GEOMETRYCOLLECTION which itself is still a geometry and also represents an
arbitrary set of geometries. Sorry if all this is
confusing.</SPAN></FONT></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=198405700-05052008></SPAN></FONT></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=198405700-05052008></SPAN></FONT></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=198405700-05052008>Hope that
helps,</SPAN></FONT></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=198405700-05052008>Regina</SPAN></FONT></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=198405700-05052008></SPAN></FONT></FONT></FONT></FONT></FONT> </DIV>
<DIV><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Bob
Pawley<BR><B>Sent:</B> Sunday, May 04, 2008 8:30 PM<BR><B>To:</B> PostGIS Users
Discussion<BR><B>Subject:</B> Re: [postgis-users]
st_makeline<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2>Thanks for your answer.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is geometry and geometry set explained
anywhere??</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Bob</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=drew@olvec.net href="mailto:drew@olvec.net">Drew Sheedy</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users
Discussion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, May 04, 2008 4:37 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [postgis-users]
st_makeline</DIV>
<DIV><BR></DIV>Hi Bob,<BR><BR>I'm new to postgis as well (and am and loving
it).<BR><BR>You do have syntax errors in your sql. Note the definitions of the
functions that you are using from the postgis manual:<BR><BR><SPAN
class=term>ST_MakePoint(<x>, <y>, [<z>],
[<m>])<BR></SPAN><SPAN class=term>ST_MakeLine(geometry
set)<BR></SPAN><SPAN class=term>ST_MakeLine(geometry,
geometry)</SPAN><BR><BR>So your point sql is valid as it accepts integers,
though your line sql is not because you are not using a geometry
type.<BR><BR>Try the following: st_makeLine(st_makePoint(0, 2),
st_makePoint(0, 1))<BR><BR>HTH<BR><BR>Drew<BR><BR>
<DIV class=gmail_quote>On Mon, May 5, 2008 at 8:15 AM, Bob Pawley <<A
href="mailto:rjpawley@shaw.ca">rjpawley@shaw.ca</A>> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hi<BR><BR>I
am trying to learn the basics of Postgis by populating a table with various
geometries.<BR><BR>When I run this -<BR>Insert into graphics.process
(the_geom) values (st_makepoint(0 2));<BR><BR>it results in a point which I
can see on the viewer.<BR><BR>However, when I run the following, or any
variation of coordinate syntax to obtain a line, I get a syntax
error.<BR><BR>Insert into graphics.process (the_geom) values (st_makeline (0
2), (0 1));<BR>Or<BR>Insert into graphics.process (the_geom) values
(st_makeline (0 2, 0 1));<BR>Or<BR>Insert into graphics.process (the_geom)
values (st_makeline (0 2 0 1));<BR>Or<BR>Insert into graphics.process
(the_geom) values (st_makeline (0, 2, 0, 1));<BR>Or<BR>Insert into
graphics.process (the_geom) values (st_makeline (0, 2), (0, 1));<BR><BR>Any
thoughts would be
appreciated.<BR><BR>Bob<BR><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></BLOCKQUOTE></DIV><BR>
<P>
<HR>
<P></P>_______________________________________________<BR>postgis-users
mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></BLOCKQUOTE></BODY></HTML>