COMPUTED BY fields or equivalent?

Поиск
Список
Период
Сортировка
От Paul Ganainm
Тема COMPUTED BY fields or equivalent?
Дата
Msg-id MPG.1a3bb9d5fb9a7e219896a9@news.gmane.org
обсуждение исходный текст
Ответы Re: COMPUTED BY fields or equivalent?
Список pgsql-novice

Hi all,


I use Interbase (starting on PostgreSQL) which has a concept of

CREATE TABLE My_Table
(
  First_Name VARCHAR(15),
  Last_Name  VARCHAR(15),
  Full_Name  VARCHAR(30) COMPUTED BY(First_Name || ' ' || Last_Name)
}

Full_Name is now a read only field in My_Table.


Is there an equivalent in PostgreSQL.

I would also be interested in hearing if this concept exists in other
RDBMS's.

TIA.


Paul...


--

plinehan  x__AT__x  yahoo  x__DOT__x  com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump and pg_restore
Следующее
От: Tom Lane
Дата:
Сообщение: Re: COMPUTED BY fields or equivalent?