[postgis-users] FW: Problem with correlative ID after using INSERT INTO
strk at keybit.net
Thu Oct 6 12:27:32 PDT 2011
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.
() Free GIS & Flash consultant/developer
More information about the postgis-users