[SQL] view does not show all records it should

2001-02-12 Thread Giovanni Biscuolo
I set up a simple database in wich all works well, exept one *very* strange (to me) result. Some time ago I created this views: CREATE VIEW mag_scaricati_view AS SELECT s.id_carico, SUM(s.qta_scaricata) AS Scaricati FROM mag_scarico_tbl s GROUP BY s.id_carico; CREATE VIEW

Re: [SQL] view does not show all records it should

2001-02-12 Thread Tom Lane
Giovanni Biscuolo [EMAIL PROTECTED] writes: CREATE VIEW mag_scaricati_view AS SELECT s.id_carico, SUM(s.qta_scaricata) AS Scaricati FROM mag_scarico_tbl s GROUP BY s.id_carico; Grouped views don't work very well in versions before 7.1, though I'm not sure if that is the issue here or

Re: [SQL] view does not show all records it should

2001-02-12 Thread Ross J. Reedstrom
On Mon, Feb 12, 2001 at 03:54:39PM +0100, Giovanni Biscuolo wrote: I set up a simple database in wich all works well, exept one *very* strange (to me) result. Some time ago I created this views: CREATE VIEW mag_scaricati_view AS SELECT s.id_carico, SUM(s.qta_scaricata) AS Scaricati