Hi Pari, Phoenix supports views in version 3.0 and higher only.
Thanks, Eli On Mon, Sep 29, 2014 at 12:08 AM, Pariksheet Barapatre <[email protected] > wrote: > Hi All, > > I am trying to create view on table given in phoenix website - > > CREATE TABLE product_metrics ( > metric_type CHAR(1) NOT NULL, > created_by VARCHAR, > created_date DATE, > metric_id INTEGER > CONSTRAINT pk PRIMARY KEY (metric_type)); > > CREATE VIEW mobile_product_metrics (carrier VARCHAR, dropped_calls BIGINT) > AS > SELECT * FROM product_metrics > WHERE metric_type = 'm'; > > But its giving error - > Error: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column > 76. (state=42P00,code=602) > > Any clue, I am using phoenix 2.2.3. > > Many Thanks > Pari >
