Hello,
I'm trying to get a table, composed of other two tables, but the correlative ID
of one of them changes, it "jumps", this is what happens:
**************
id | name
...
34 | 79-051
35 | 79-052
52 | 79-076
214 | 96-008A
215 | | 96-009
36 | 79-053
37 | 79-055
....
****************
this shape was inserted as follows:
shp2pgsql -s 4326 -W UTF-8 -g geom -I -D /home/postgres/shp/line/line.shp |
psql -U postgres -d mydb
after checking it in my db, it looks like:
**********
...
34 | 79-051
35 | 79-052
36 | 79-053
37 | 79-055
...
**********
this is the part of the code I used to insert this table:
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;
I tried adding "ORDER BY ID" at the end of the second line (after "line") but
didn't work.
Any suggestions are very welcome, thanks in advance,
Gery
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
