are views obsolete ?
От | Karsten Hilbert |
---|---|
Тема | are views obsolete ? |
Дата | |
Msg-id | 20030519130728.B21927@hermes.hilbert.loc обсуждение исходный текст |
Ответы |
Re: are views obsolete ?
|
Список | 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
В списке pgsql-general по дате отправления: