COMPUTED BY fields or equivalent? - Mailing list pgsql-novice

From Paul Ganainm
Subject COMPUTED BY fields or equivalent?
Date
Msg-id MPG.1a3bb9d5fb9a7e219896a9@news.gmane.org
Whole thread Raw
Responses Re: COMPUTED BY fields or equivalent?
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump and pg_restore
Next
From: Tom Lane
Date:
Subject: Re: COMPUTED BY fields or equivalent?