> > Jan, I am attaching the current TODO list. Can you tell me which items
> > are fixed in 6.4?
> >
> > --
> > Bruce Momjian | 830 Blythe Avenue
> >
>
>
> > * CREATE VIEW requires super-user priviledge
>
> Fixed - regular users can create views and rules
>
> > * views on subselects fail
>
> Must check that - hope it is already fixed
>
> > * computations in views fail:
> > create view test as select usesysid * usesysid from pg_shadow;
>
> Will check this too
>
> > * Add full ANSI SQL capabilities
> > * -Implement HAVING clause(Stephan)
> > * add OUTER joins, left and right (Thomas)
> > * make VIEWs updateable where possible
>
> Rules can be used to make views updateable
>
> > * Fix the rules system(Jan,Soo-Ho)
> > * robust
> > * making INSTEAD rules work
> > * add CONSTRAINT
>
> The restricted part of rules are robust and instead rules
> work. Constraints could be implemented as rules but would
> require a new RAISE statement. I'll work on constraints
> for 6.5.
>
> > * Allow INSERT INTO ... SELECT ... FROM view to work
>
> Should work - will check it.
>
> > * Allow views on a UNION
> > * Allow DISTINCT on view
> > * Allow views of aggregate columns
>
> Check - not yet - check
>
> > * 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?
I have updated the TODO list. If you find more items you have fixed,
let me know. The rewrite system had a large chunk of the TODO list.
That is why I was so excited when you said you could fix it.
--
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)