user/sven/postgresql.git

Age	Commit message (Collapse)	Author
2000-10-05	Reimplementation of UNION/INTERSECT/EXCEPT. INTERSECT/EXCEPT now meet the	Tom Lane
	SQL92 semantics, including support for ALL option. All three can be used in subqueries and views. DISTINCT and ORDER BY work now in views, too. This rewrite fixes many problems with cross-datatype UNIONs and INSERT/SELECT where the SELECT yields different datatypes than the INSERT needs. I did that by making UNION subqueries and SELECT in INSERT be treated like subselects-in-FROM, thereby allowing an extra level of targetlist where the datatype conversions can be inserted safely. INITDB NEEDED!
2000-09-29	Subselects in FROM clause, per ISO syntax: FROM (SELECT ...) [AS] alias.	Tom Lane
	(Don't forget that an alias is required.) Views reimplemented as expanding to subselect-in-FROM. Grouping, aggregates, DISTINCT in views actually work now (he says optimistically). No UNION support in subselects/views yet, but I have some ideas about that. Rule-related permissions checking moved out of rewriter and into executor. INITDB REQUIRED!