Skip site navigation (1) Skip section navigation (2)

AW: AW: TODO (was: Re: [HACKERS] Problem with parser)

From: Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at>
To: "'Jan Wieck'" <jwieck(at)debis(dot)com>
Cc: "'hackers(at)postgresql(dot)org'" <hackers(at)postgresql(dot)org>
Subject: AW: AW: TODO (was: Re: [HACKERS] Problem with parser)
Date: 1998-08-28 09:07:12
Message-ID: 01BDD274.CDCF8310@zeugswettera.user.lan.at (view raw or flat)
Thread:
Lists: pgsql-hackers
>
> >> > * 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.

Yes, I think this is a parser issue.
It can be handled in the same way as the following syntax (only the above is the standard):
create view myview as select lname as name, currsal as salary, whours as hours from wages;

Andreas


pgsql-hackers by date

Next:From: Andreas ZeugswetterDate: 1998-08-28 10:27:59
Subject: long long int and printf format for int8.c
Previous:From: Tom Ivar HelbekkmoDate: 1998-08-28 07:38:05
Subject: Re: [HACKERS] vacuum problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group