Search Postgresql Archives

Re: What is the point of create or replace view command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 6/5/06, Berend Tober wrote:
Chris Velevitch wrote:
> What is the point of the create or replace view command if you can't
> change the column and data types ?

You could have a calculated column and change the calcuation.

You could change the sort order, selection, or grouping clauses.

That's what I'm trying to do but the command won't let me. So what's
the point of having such a if it won't replace the previous
definition. I ended up having to drop and the create it again. I'm
trying to understand the reasoning behind the limit in functionality
of the command. With my current understanding, it's very useful and
should be dropped from postgres.


Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux