Dear all,
i want to create partitions table :
*create table advertisements_otomotif (CHECK (select * from
advertisements where category_id in (select id from categories where
name='Otomotif'))) INHERITS (advertisements)
*
but i have error like this:
*ERROR: syntax error at or near "select"
LINE 1: create table advertisements_otomotif (CHECK (select * from a...
^
********** Error **********
ERROR: syntax error at or near "select"
SQL state: 42601
Character: 46
*any have sollutions?
thanks