Re: How to create a virtual column - Mailing list pgsql-general

From A. Kretschmer
Subject Re: How to create a virtual column
Date
Msg-id 20051107060514.GA5642@webserv.wug-glas.de
Whole thread Raw
In response to Re: How to create a virtual column  (Chris <chris.velevitch@gmail.com>)
Responses Re: How to create a virtual column  ("Jim C. Nasby" <jnasby@pervasive.com>)
List 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    ===

pgsql-general by date:

Previous
From: "Thomas F. O'Connell"
Date:
Subject: Re: Subqueries
Next
From: Tino Wildenhain
Date:
Subject: Re: PygreSQL ByteA