# [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 t
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
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
creat
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;
-- cre
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:
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
--
-
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
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
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
"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
typ
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.
---
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 posting/readin
12 matches
Mail list logo
