|
1 | 1 | TODO list for PostgreSQL |
2 | 2 | ======================== |
3 | | -Last updated:Tue Jul 2013:24:02 EDT 1999 |
| 3 | +Last updated:Tue Jul 2017:40:39 EDT 1999 |
4 | 4 |
|
5 | 5 | Current maintainer:Bruce Momjian (maillist@candle.pha.pa.us) |
6 | 6 |
|
|
39 | 39 | * CREATE TABLE x AS SELECT 1 UNION SELECT 2 fails |
40 | 40 | * CREATE TABLE test(col char(2) DEFAULT user) fails in length restriction |
41 | 41 | * SELECT ... UNION ... ORDER BY fails when sort expr not in result list |
42 | | -* INSERT ... SELECT ... UNION is not reliable |
43 | | -* Be smarter about promoting types when UNION merges different data types |
44 | | -* SELECT ... UNION ... GROUP BY fails if column types disagree |
| 42 | +* redesign INSERT ... SELECT to have two levels of target list |
45 | 43 |
|
46 | 44 | VIEWS |
47 | 45 |
|
|