373 | | Note : It is necessary to create a table as the pfafstetter along an axis can have a shorter length upstream than the length selected |
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. |
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 |
| 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 | 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) |