On Tue, Nov 06, 2012 at 05:11:48PM +0000, Pedro Costa wrote: > Thanks Sandro... > > It is possible determine the current directions before use st_reverse? Try ST_Azimuth. > I want all lines with same direction "Segments", hopefully. Lines may go zig-zag... ST_Azimuth takes two points, so it's up to you what to feed it from your lines. --strk;