Re: How to create a virtual column

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to create a virtual column
Date: 2005-11-07 06:05:14
Message-ID: 20051107060514.GA5642@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

am 06.11.2005, um 22:54:15 +0000 mailte Chris folgendes:
> Andreas Kretschmer <akretschmer <at> spamfence.net> writes:
> > Chris <chris.velevitch <at> gmail.com> schrieb:
> >
> > > How do I create a virtaul column?
> >
> > A view. Example:
>
> Is a view completely compatible with tables? I mean, can I do everything with a
> view like I can do to a table, like insert, delete or update?

No, only insert. But you can also define RULEs for update and delete.
http://www.postgresql.org/docs/8.0/interactive/rules-update.html#RULES-UPDATE-VIEWS

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2005-11-07 07:38:22 Re: PygreSQL ByteA
Previous Message Thomas F. O'Connell 2005-11-07 05:55:09 Re: Subqueries