[postgis-users] abs_next_left_edge and next_left_edge
Sandro Santilli
strk at keybit.net
Wed Mar 19 04:51:49 PDT 2014
On Wed, Mar 19, 2014 at 11:53:33AM +0100, Rémi Cura wrote:
> Hey Dear List,
>
> somebody knows exactly what is the difference bteween those 2 columns in
> postgis topology?
The "abs" one was just a facility to allow for
the field to be a valid foreign key into edge_id.
Not sure it's still needed with newer postgresql,
haven't tried. Would be something like:
FOREIGN KEY ( abs(next_left_edge) )
REFERENCES <toponame>.edge (edge_id);
Let me know if you find anything interesting
about that. Would save 2 "abs" fields per record
in the edge table...
--strk;
More information about the postgis-users
mailing list