>> > * Allow views to specify column names outside SELECT statement
>> 
>>     ??? what is meant by that?
>
>I have no idea.  I am removing it.  Does anyone else know what it means?

It probably means:
create view myview (name, salary, hours) as select lname, currsal, whours from wages;

Andreas



Thu, 27 Aug 1998 09:05:39 +0200
Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
AW: TODO (was: Re: [HACKERS] Problem with parser)
> >> > * Allow views to specify column names outside SELECT statement
> >> 
> >>     ??? what is meant by that?
> >
> >I have no idea.  I am removing it.  Does anyone else know what it means?
> 
> It probably means:
> create view myview (name, salary, hours) as select lname, currsal, whours from wages;

Added to TODO:

	* CREATE VIEW myview (name) AS SELECT lname FROM wages fails        


-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Thu, 27 Aug 1998 13:01:21 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: AW: TODO (was: Re: [HACKERS] Problem with parser)
>
> >> > * Allow views to specify column names outside SELECT statement
> >>
> >>     ??? what is meant by that?
> >
> >I have no idea.  I am removing it.  Does anyone else know what it means?
>
> It probably means:
> create view myview (name, salary, hours) as select lname, currsal, whours from wages;
>
> Andreas

    But that doesn't have to do anything with the rewrite system.
    It has to do with the view creation step on  setting  up  the
    instead rule for view selection. There the AS clauses have to
    be moved into the target list.  The  rewrite  system  doesn't
    know if this rule is something that builds up a view.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #



Thu, 27 Aug 1998 22:41:16 +0200 (MET DST)
jwieck@debis.com (Jan Wieck)
Re: AW: TODO (was: Re: [HACKERS] Problem with parser)