On 6/5/06, Joe Conway wrote:
Chris Velevitch wrote:
But what about my original question?
What is the point of the create or replace view command if you
can't change the
column and data types?
-- create table t1
create table t1(f int);
-- create view v1 based on table t1
create view
Chris Velevitch wrote:
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,
# [EMAIL PROTECTED] / 2006-06-05 16:19:19 +1000:
On 6/5/06, Joe Conway wrote:
Chris Velevitch wrote:
But what about my original question?
What is the point of the create or replace view command if you
can't change the
column and data types?
-- create table t1
create table
What is the point of the create or replace view command if you can't
change the column and data types ?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
---(end of broadcast)---
TIP 1: if
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.
Chris Velevitch [EMAIL PROTECTED] writes:
What is the point of the create or replace view command if you can't
change the column and data types ?
You might as well ask what's the point of CREATE OR REPLACE FUNCTION,
when it doesn't let you change the function's parameter list or result
type.
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.
On 6/5/06, Tom Lane wrote:
Chris Velevitch [EMAIL PROTECTED] writes:
What is the point of the create or replace view command if you can't
change the column and data types ?
You might as well ask what's the point of CREATE OR REPLACE FUNCTION,
when it doesn't let you change the function's
Chris Velevitch wrote:
On 6/5/06, Tom Lane wrote:
Chris Velevitch [EMAIL PROTECTED] writes:
What is the point of the create or replace view command if you can't
change the column and data types ?
You might as well ask what's the point of CREATE OR REPLACE FUNCTION,
when it doesn't let you
Chris Velevitch wrote:
Yes, please, what is point of CREATE OR REPLACE FUNCTION, when it
doesn't let you change the function's parameter list or result type?
Being able to change the _logic_ of a function is certainly useful.
Well, I find it so, at least - YMMV.
Tim
--
On 6/5/06, brian ally wrote:
Chris Velevitch wrote:
Yes, please, what is point of CREATE OR REPLACE FUNCTION, when it
doesn't let you change the function's parameter list or result type?
The way that user-created functions work allows one to have the same
function name with different numbers
Chris Velevitch wrote:
But what about my original question?
What is the point of the create or replace view command if you
can't change the
column and data types?
-- create table t1
create table t1(f int);
-- create view v1 based on table t1
create view v1 as select * from t1;
--
12 matches
Mail list logo