[postgis-users] creating linestrings from points, complexish linestrings

[Rhys Stewart]

Hi all,

I have the following table:

CREATE TABLE tmp.children
(
  parish character varying(50),
  pointnumber numeric(18),
  parent character varying(254),
  devicetype character varying(50),
  coordfix geometry
)

The table holds a parent-child relationship in columns pointnumber and parent.
i.e., if a point has a parent the pointnumber  for that parent is in
the parent field.
The devicetype can either be Start, Inter or End. The only time a row
has no parent is when its devicetype is start. There can be any number
of inters.

I would like to create one linestring encompassing an entire
start-inter-end sequence and am having trouble wrapping my brain
around it.


Any suggestions?


Thanks