Re: [SQL] Ordering in an aggregate -- points to paths

"Julian Scarfe" <[EMAIL PROTECTED]> writes: > OK, I know relying on ordering in an aggregate is sinful, but I don't know > if it's mortal or venial. > ... > SELECT c.fir_ident, c.fir_indicator, create_path (c.node) AS fir_edge >INTO fir_e >FROM >(SELECT fir_ident, fir_indica

[SQL] Ordering in an aggregate -- points to paths

OK, I know relying on ordering in an aggregate is sinful, but I don't know if it's mortal or venial. Long explanation, please bear with me, here's the background: --- CREATE TABLE "foo" ( "a" point, "b" int ); INSERT INTO ... SELECT * FROM foo; a| b -+--- (1,1)

[SQL] Where of an aggregate

HI! Try this select c.traffic from (select sum(bytes) as traffic from traffic_table group by ip) c where c.traffic<(100*1024*1024); ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregis