pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (3+ messages)  latest in thread

Message-ID: <20010212095346.B24537@rice.edu>
Permalink:  ../20010212095346.B24537@rice.edu/
Also on:    postgresql.org/message-id/20010212095346.B24537@rice.edu

 · 

reply

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