[postgis-users] Compare two rows in one table ?

[Tuomas Ruohonen]

Hi,

I have next difficult question :) !

"mytable"
id      result
1        26
1        25
1        25
1        25
1        24
1        24
1        23
1        21

Compare two rows in table, when result changes more than 2 query shows only those rows. In this case query ignores 25,25,25,24,23 and shows only 26,24 and 21. There should be always one number only if the number is same, like 24 and 24, shows only one 24.
Is this even possible ? I hope you can understand what i mean in this case...

_________________________________________________________________
Uudessa IE8 selaimessa on uudet pikatoiminnot.
http://www.microsoft.com/finland/windows/products/winfamily/ie/beta/default.mspx
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090923/5bc6a654/attachment.html>