[GENERAL] question abut "order by" null fields

: In the rows where Column1 is null, postgres don't perform ORDER BY on the column2 Why? Same behavior when: SELECT column1, column2 FROM table1 LEFT JOIN table2 USING (id) ORDER BY coalesce(column1,''), column2 Thanks in advance -- ------- Ales

[GENERAL] Not use index on setof from Sql Function

23..6.289 rows=504 loops=1) Index Cond: (("Categoria" = 1) AND ("Tipologia" = 'ALB'::bpchar)) Total runtime: 9.565 ms ### Can I use index on setof from _stato_dati_regione_rt(text)? Tannks in adbace. By,Alessandro -- --- Ale

[GENERAL] passing new.* in trigger

eclare room int; BEGIN SELECT INTO camere count_room(NEW.*) FROM NEW ; NEW.camere = camere; RETURN NEW; END; ' LANGUAGE 'plpgsql' VOLATILE; -- ------- Alessandro Vincelli W4B - web for business s.r.l. Firenze via Pellicceria 10 - 50123 E-ma