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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
