On Tue, Jul 30, 2013 at 09:23:19AM +0100, Dean Rasheed wrote:
create table some_data (id int4 primary key, payload text);
create view first as select * from some_data where 0 = id % 2 with
local check option;
create view second as select * from first where 0 = id with local
On Tue, Jul 30, 2013 at 11:45:47AM +0100, Dean Rasheed wrote:
Quoting the manual:
LOCAL:
New rows are only checked against the conditions defined directly in
the view itself. Any conditions defined on underlying base views are
not checked (unless they also specify the CHECK OPTION).
depesz,
moved to -hackers..
* hubert depesz lubaczewski (dep...@depesz.com) wrote:
create table some_data (id int4 primary key, payload text);
create view first as select * from some_data where 0 = id % 2 with local
check option;
create view second as select * from first where 0 = id with
On Mon, Jul 29, 2013 at 07:43:53PM -0400, Stephen Frost wrote:
depesz,
moved to -hackers..
* hubert depesz lubaczewski (dep...@depesz.com) wrote:
create table some_data (id int4 primary key, payload text);
create view first as select * from some_data where 0 = id % 2 with local
check
depesz,
* hubert depesz lubaczewski (dep...@depesz.com) wrote:
On Mon, Jul 29, 2013 at 07:43:53PM -0400, Stephen Frost wrote:
* hubert depesz lubaczewski (dep...@depesz.com) wrote:
create table some_data (id int4 primary key, payload text);
create view first as select * from some_data