From: Giovanni Biscuolo <giovanni.biscuolo@libero.it>
To: pgsql-sql@postgresql.org
Subject: view does not show all records it should
Date: Mon, 12 Feb 2001 15:54:39 +0100
Message-ID: <3A87F92F.49345962@libero.it> (raw)
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 mag_giacenza1_view AS
SELECT c.ref AS "Ref.",
p.descrizione_breve AS Descrizione,
c.id_carico AS "Scheda di carico",
c.qta_caricata AS "Caricati",
s.Scaricati,
(c.qta_caricata-s.Scaricati) AS "Giacenza"
FROM mag_carico_tbl c, mag_scaricati_view s , prd_ref_tbl p
WHERE (c.id_carico = s.id_carico) AND
(c.ref = p.ref);
Now, when I issue the following command:
SELECT * FROM mag_giacenza1_view
it shows me the records that was in the database the day
I created the view, _not all the records in the database_.
If I select "by hand" with the following statament (please
note it is the very same with which I created the view):
SELECT c.ref AS "Ref.",
p.descrizione_breve AS Descrizione,
c.id_carico AS "Scheda di carico",
c.qta_caricata AS "Caricati",
s.Scaricati,
(c.qta_caricata-s.Scaricati) AS "Giacenza"
FROM mag_carico_tbl c, mag_scaricati_view s , prd_ref_tbl p
WHERE (c.id_carico = s.id_carico) AND
(c.ref = p.ref);
it shows me all the records.
Please, is there anybody who can help me, I can't even imagine what's
happening. :-(((
Ciao.
--
____________________________________
Giovanni Biscuolo
mailto:giovanni.biscuolo@libero.it
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: giovanni.biscuolo@libero.it
Subject: Re: view does not show all records it should
In-Reply-To: <3A87F92F.49345962@libero.it>
References: <3A87F92F.49345962@libero.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox