Message-ID: <3DB2032A.496345A1@technovell.com>
Date: Sun, 20 Oct 2002 03:13:14 +0200
From: Terry Yapt <yapt@technovell.com>
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Restricting a VIEW.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello all,

I have a doubt.  In the next example, I have a table with two columns:
- DATE
- MONEY

And a VIEW which SUM's the money GROUPing by 'month/year' (I cut off the day)...

Ok.. I would like to be able to SELECT * FROM VIEW.. but restricting by complete dates (dd/mm/yyyy)... (Last select in the example)

I think it isn't possible, but I would like to know your opinion... Or if there is any workaround...

Best regards..

--==============================
DROP TABLE ty_test;
CREATE TABLE ty_test
  (datein date NOT NULL,
   money  numeric(6,2) NOT NULL,
  PRIMARY KEY (datein)
) WITHOUT OIDS;

INSERT INTO ty_test VALUES ('2002/10/01',10);
INSERT INTO ty_test VALUES ('2002/10/15',20);
INSERT INTO ty_test VALUES ('2002/11/15',30);

DROP VIEW vw_ty_test;
CREATE VIEW vw_ty_test AS
    SELECT
        TO_CHAR(datein,'MM/YYYY') AS datein2,
        SUM(money)
      FROM
        ty_test
      GROUP BY
        datein2;

SELECT * FROM ty_test;      -- All rows from table.
SELECT * FROM vw_ty_test;   -- All rows from view.

SELECT * FROM vw_ty_test WHERE datein BETWEEN '2002/10/01' AND '2002/10/9';
--==============================