Re: [SQL] inheritance

Поиск
Список
Период
Сортировка
От Oliver Elphick
Тема Re: [SQL] inheritance
Дата
Msg-id 199805291958.UAA05205@linda.lfix.co.uk
обсуждение исходный текст
Ответ на inheritance  (Bernhard Matthias Ertl <ertl@delos.dbs.informatik.uni-muenchen.de>)
Список pgsql-sql
Bernhard Matthias Ertl wrote:
  >Hi,
  >
  >only two short questions:
  >+ does the postgresql 6.2.1 already support inheritance and
  >+ if I have the tables cities and capitals (like in the tutorial), how can
  >I add attributes of a city to a capital? Before the capital attributes,
  >after the capital attributes or do I have to insert a capital citiy into
  >the table city as well as into the table capital?
A descendant automatically inherits all attributes from its ancestor(s).

Try \d and see.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Let no man despise thy youth; but be thou an example
      of the believers, in word, in conversation, in
      charity, in spirit, in faith, in purity."
                                       I Timothy 4:12



В списке pgsql-sql по дате отправления:

Предыдущее
От: Bernhard Matthias Ertl
Дата:
Сообщение: inheritance
Следующее
От: Bassel Hatoum
Дата:
Сообщение: Trouble with dates