<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16640" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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>