Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the point of create or replace view command - Mailing list pgsql-general

From Berend Tober
Subject Re: What is the point of create or replace view command
Date
Msg-id 448390BB.2040607@seaworthysys.com
Whole thread Raw
In response to What is the point of create or replace view command  ("Chris Velevitch" <chris.velevitch@gmail.com>)
Responses Re: What is the point of create or replace view command
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "Chris Velevitch"
Date:
Subject: What is the point of create or replace view command
Next
From: Tom Lane
Date:
Subject: Re: What is the point of create or replace view command