[postgis-users] FW: Problem with correlative ID after using INSERT INTO

[Sandro Santilli]

On Thu, Oct 06, 2011 at 06:41:21PM +0000, Gery . wrote:
> 
> 
> Thanks Paul, I put ORDER BY ID before Select and after it but didn't work. Could you provide me please an example based on the code below?
> 
> INSERT INTO both_lines (ID, SURVEY, PROFILE, TYPE, SOURCE, LENGTH_KM, LENGTH_NM, COMMENTS, GEOM)
> SELECT ID, SURVEY, PROFILE, TYPE, SOURCE, LENGTH_KM, LENGTH_NM, COMMENTS, GEOM FROM line;

The above query _inserts_ data. Ordering doesn't make sense on insert.
You want to order at query time.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html