[postgis-users] Fw: please help me about postgis

[alireza ghahremanian]

I have a table like this:

CREATE TABLE test
(
  id integer NOT NULL,
  x double precision,
  y double precision,
  CONSTRAINT test_pk PRIMARY KEY (id)
) 
WITHOUT OIDS;

which contains some coordinates  (x,y) of a track now I want to insert a geometry entry from this data in another table with a SELECT command something like this

SELECT  GeomFromText('LINESTRING(x y)') FROM test;

but it does not work please help me. I should note that the data in table test will update every 5 sec. so I must my geometry tables with respect to test table data.

with special thanks









 
____________________________________________________________________________________
Food fight? Enjoy some healthy debate 
in the Yahoo! Answers Food & Drink Q&A.
http://answers.yahoo.com/dir/?link=list&sid=396545367

Dear Sandro Santilli




 
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited