How to create a virtual column

From: Chris <chris(dot)velevitch(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to create a virtual column
Date: 2005-11-06 02:58:15
Message-ID: loom.20051106T035357-965@post.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How do I create a virtaul column?

A virtual column is accessible like any other column except that there is no
physical column associated with it (unless it's indexed). The data for the
column is derived from other columns in the table. For example, in a table
people, a persons name is the concatentation if their first, middle and surnames.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-11-06 03:22:30 Re: Setting max_fsm_pages
Previous Message Carlos Oliva 2005-11-06 02:44:09 Setting max_fsm_pages