Re: Visibility of data from table inherits function

2022-01-03 Thread Francisco Olarte
On Sun, 2 Jan 2022 at 20:42, ourdiaspora wrote: > On Sunday, January 2nd, 2022 at 3:54 PM, Francisco Olarte > wrote: > > Inherits does not copy things. LIKE on creation does, but AFAIK it can > > copy nearly everything except data. > Thanks, had read that part of the documentation. > So far it s

Re: Visibility of data from table inherits function

2022-01-02 Thread Achilleas Mantzios
Στις 2/1/22 2:23 μ.μ., ο/η ourdiaspora έγραψε: Recipients, A table was created: CREATE TABLE exampletable ( name varchar(200) ); Table 'exampletable' _already_ contains data, e.g. 'Jane Bloggs' A new table was created with inheritance of 'exampletable': Please could someone explain why the

Re: Visibility of data from table inherits function

2022-01-02 Thread Adrian Klaver
On 1/2/22 11:41, ourdiaspora wrote: On Sunday, January 2nd, 2022 at 3:54 PM, Francisco Olarte wrote: Inherits does not copy things. LIKE on creation does, but AFAIK it can copy nearly everything except data. Thanks, had read that part of the documentation. So far it seems that functions

Re: Visibility of data from table inherits function

2022-01-02 Thread ourdiaspora
On Sunday, January 2nd, 2022 at 3:54 PM, Francisco Olarte wrote: > > Inherits does not copy things. LIKE on creation does, but AFAIK it can > > copy nearly everything except data. > Thanks, had read that part of the documentation. So far it seems that functions 'joins' may be used to view data,

Re: Visibility of data from table inherits function

2022-01-02 Thread Francisco Olarte
On Sun, 2 Jan 2022 at 13:23, ourdiaspora wrote: > CREATE TABLE exampletable ( > name varchar(200) > ); ... > CREATE TABLE exampletablechild (dates DATE) INHERITS (exampletable); ... > Please could someone explain why the data in the table 'exampletable' is not > visible from the query using the c

Re: Visibility of data from table inherits function

2022-01-02 Thread David G. Johnston
On Sunday, January 2, 2022, ourdiaspora wrote: > > > Please could someone explain why the data in the table 'exampletable' is > not visible from the query using the child table? > > Does not 'INHERIT' function apply to the data of the precedent parent > table? > > Apparently not…and you can readi