phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pariksheet Barapatre <pbarapa...@gmail.com>
Subject Phoenix View creation error
Date Mon, 29 Sep 2014 07:08:07 GMT
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

Mime
View raw message