are views obsolete ?

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: are views obsolete ?
Date: 2003-05-19 11:07:28
Message-ID: 20030519130728.B21927@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all

given the power of SETOF/ROWTYPE functions etc are select-only
views becoming obsolete/redundant ? IOW, do views only make
sense any longer when I add delete/insert/update rules to them
because the "select aggregation" advantage can be achieved
with SRFs, too (and more powerful at that) ? And even then
INSERTs could be replaced by standard functions, too (as could
updates/deletes but that would be ugly because one would have
to group where-condition values with update-attribute values,
at least for the UPDATE case).

I have not found a thread discussing the *relative advantages*
of views vs. SRFs in the archives... I am sure it's quite
clear to the more involved people. The only advantage of SRFs
over views that I can see is that in an SRF I have the power
of procedural languages immediately available while in a view
definition I would have to call individual functions to
dynamically computer column values.

Pointers would be appreciated.

Thanks,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

Responses

Browse pgsql-general by date

  From Date Subject
Next Message fliptop 2003-05-19 11:57:03 Re: mod_perl + PostgreSQL implementation
Previous Message Tzvetan Tzankov 2003-05-19 09:55:04 Re: disk space usage enlarging despite vacuuming