From: Ross J. Reedstrom <reedstrm@rice.edu>
To: Giovanni Biscuolo <giovanni.biscuolo@libero.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: view does not show all records it should
Date: Mon, 12 Feb 2001 09:53:46 -0600
Message-ID: <20010212095346.B24537@rice.edu> (raw)
In-Reply-To: <3A87F92F.49345962@libero.it>
References: <3A87F92F.49345962@libero.it>
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
> 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):
>
Are you absolutely sure you did "CREATE VIEW" and not "CREATE TABLE" ?
PostgreSQL allows you to create a table by selecting from existing
tables. The sytax _exactly_ matches the create view syntax, except
for the single word TABLE vs. VIEW.
You can test this from pgsql with: \d mag_giacenza1_view
If it's a view, you'll see the column definitions, plus the parsed
version of the SELECT you used to create it.
If it's a table, you'll just see the column defines.
Which version of PostgreSQL are you using, BTW?
Ross
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: reedstrm@rice.edu, giovanni.biscuolo@libero.it
Subject: Re: view does not show all records it should
In-Reply-To: <20010212095346.B24537@rice.edu>
References: <3A87F92F.49345962@libero.it> <20010212095346.B24537@rice.edu>
* 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