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

Paul Ganainm <paulsnewsgroups@hotmail.com> writes:
> 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)
> }

You could do that with a view (if you don't want the derived field to be
physically stored on disk) or with a trigger (if you do).

            regards, tom lane