[postgis-devel] TWKB_agg broken ?

[Sandro Santilli]

Nicklas, I was looking at ST_AsTWKB_agg but I think it's broken.
Why would otherwise the output of ST_AsTWKB_agg be smaller than
the output of ST_AsTWKB ?

See below:

strk=# select sum(octet_length(o)) from ( select ST_AsTWKB(g,0) o from
( select the_geom g from lots_of_points limit 10000 ) b ) f;
  sum
-------
 60000
(1 row)
Time: 15.936 ms

strk=# select sum(octet_length(o)) from ( select ST_AsTWKB_agg(g,0) o from
( select the_geom g from lots_of_points limit 10000 ) b ) f;
  sum
-------
 20006
(1 row)
Time: 13.248 ms

--strk; 

 ()  ASCII ribbon campaign  --  Keep it simple !
 /\  http://strk.keybit.net/rants/ascii_mails.txt