COMPUTED BY fields or equivalent?

From: Paul Ganainm <paulsnewsgroups(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: COMPUTED BY fields or equivalent?
Date: 2003-12-06 10:03:36
Message-ID: MPG.1a3bb9d5fb9a7e219896a9@news.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message epz 2003-12-06 14:11:21 newbie needs help seting up for gentoo
Previous Message Tom Lane 2003-12-06 04:08:15 Re: pg_dump and pg_restore