phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eli Levine <elilev...@gmail.com>
Subject Re: Updatable view
Date Wed, 09 Jul 2014 23:56:46 GMT
Kiru, only basic equality expressions are supported for creating updateable
views. Please file a Jira if you have specific requirements for supporting
more complex WHERE clauses in updateable views.

Thanks,

Eli



On Wed, Jul 9, 2014 at 4:48 PM, Kiru Pakkirisamy <kirupakkirisamy@yahoo.com>
wrote:

> Can't we  not use even string functions in the CONSTRAINT of a view ? I
> get 'table is read only' when I upsert into the view.
>
> where (SUBSTR(TO_CHAR(SampleDate), 0,4) = '2014');
>
>
> Regards,
> - kiru
>
>
> Kiru Pakkirisamy | webcloudtech.wordpress.com
>

Mime
View raw message