Thanks Eli, will do.
Regards,
- kiru
Kiru Pakkirisamy | webcloudtech.wordpress.com
From: Eli Levine
To: user@phoenix.apache.org; Kiru Pakkirisamy
Sent: Wednesday, July 9, 2014 4:56 PM
Subject: Re: Updatable view
Kiru, only basic equality expressions
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
wrote:
> Can't we not use even
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
