phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eli Levine <elilev...@gmail.com>
Subject Re: Phoenix View creation error
Date Mon, 29 Sep 2014 15:24:08 GMT
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 <pbarapatre@gmail.com
> 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
>

Mime
View raw message