[postgis-devel] Btree semantic (was: [postgis-users] Strange behaviour of = operator)

strk strk at keybit.net
Wed Feb 8 08:06:56 PST 2006


[ added postgis-devel ]

On Wed, Feb 08, 2006 at 02:30:41PM +0200, Steffen Macke wrote:
> > I'm ready to reopen this, as far as current semantic is not
> > documented in the manual.
> 
> Well, I think having an easy and intuitive way to check for duplicate
> geometries is something great. Thus if
> 
> select count(distinct the_geom) from test;
> 
> and
> 
> select the_geom,count(*) from test group by the_geom;
> 
> work like they do after the changes mentioned in this thread,
> PostGIS becomes a more powerful tool.

Sounds fair. What about order by ? Is area a nice one for it ?
Paul, what do you think ?

--strk;



More information about the postgis-devel mailing list