phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kiru Pakkirisamy <kirupakkiris...@yahoo.com>
Subject Re: Updatable view
Date Thu, 10 Jul 2014 00:17:47 GMT
Thanks Eli, will do.
 
Regards,
- kiru


Kiru Pakkirisamy | webcloudtech.wordpress.com


________________________________
 From: Eli Levine <elilevine@gmail.com>
To: user@phoenix.apache.org; Kiru Pakkirisamy <kirupakkirisamy@yahoo.com> 
Sent: Wednesday, July 9, 2014 4:56 PM
Subject: Re: Updatable view
 


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