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

From: Berend Tober <btober(at)seaworthysys(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is the point of create or replace view command
Date: 2006-06-05 02:02:35
Message-ID: 448390BB.2040607@seaworthysys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Just to name two.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-06-05 02:44:50 Re: What is the point of create or replace view command
Previous Message Chris Velevitch 2006-06-05 01:50:33 What is the point of create or replace view command