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