Visibility of data from table inherits function
От | ourdiaspora |
---|---|
Тема | Visibility of data from table inherits function |
Дата | |
Msg-id | -YOusR_95io8hzFnscly6yFVD7ssgOhG0dnTRskP2hU2TaCDS29X2XIxNaYAKjZjYdYYYVF87qlFcmzDHIgw-9ooalVT6DkLDnd6cLqHCko=@protonmail.com обсуждение исходный текст |
Ответы |
Re: Visibility of data from table inherits function
Re: Visibility of data from table inherits function Re: Visibility of data from table inherits function |
Список | pgsql-general |
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': CREATE TABLE exampletablechild (dates DATE) INHERITS (exampletable); SET DATESTYLE TO 'SQL, EUROPEAN'; \d exampletablechild " ... Inherits: exampletable " SELECT name FROM exampletablechild; " name ------ (0 rows) " SELECT name FROM exampletable; " name -------------- jane bloggs " 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?
В списке pgsql-general по дате отправления: