Changes between Version 59 and Version 60 of CCM2 download and load
- Timestamp:
- Apr 5, 2010 6:31:30 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CCM2 download and load
v59 v60 373 373 Note : It is necessary to create a table as the pfafstetter along an axis can have a shorter length upstream than the length of the selected segment [[BR]] 374 374 The maximum length for a pfafstetter is 14 in the ccm. Transforming the database to store a column number with 14 number would increase the size of the database. [[BR]] 375 It is also not possible to create a variable in PlSql storing more than one line. For these two reasons, a table upstream_segments is created and is filled with the segments of the basin, and further reduced to the segments upstream from the segment passed as parameter to the function. The function returns a resultset of integer values (gid)375 It is also not possible to create a variable in plpgsql storing more than one line. For these two reasons, a table upstream_segments is created and is filled with the segments of the basin, and further reduced to the segments upstream from the segment passed as parameter to the function. The function returns a resultset of integer values (gid) 376 376 {{{ 377 377 DROP TYPE IF EXISTS gid;