[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] abs_next_left_edge and next_left_edge
From:       Sandro Santilli <strk () keybit ! net>
Date:       2014-03-19 11:51:49
Message-ID: 20140319115149.GH4042 () localhost
[Download RAW message or body]

On Wed, Mar 19, 2014 at 11:53:33AM +0100, R=E9mi 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;
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]