* Select a[1] FROM test fails, it needs test.a[1]

* Array index references without table name cause problems

* Update table SET table.value = 3 fails

* Creating index oftimestamp fails

* Creating index ofTIMESTAMP fails, rename to DATETIME(Thomas)

* SELECT foo UNION SELECT foo is incorrectly simplified to SELECT foo

* INSERT ... SELECT ... GROUP BY groups by target columns not source columns

* CREATE TABLE test (a char(5) DEFAULT text '', b int4) fails on INSERT

VIEWS

* Large objects

o Fix large object mapping scheme, own typeid or reltype(Peter)

o Allow large text type to use large objects(Peter)

o Not to stuff everything as files in a single directory

o Not to stuff everything as files in a single directory, hash dirs

o Allow large object vacuuming

* Allow pg_descriptions when creating types, tables, columns, and functions

* Add IPv6 capability to INET/CIDR types

* Make a separate SERIAL type?

* Allow LOCALE on a per-column basis, default to ASCII

* Allow array on int8[]

* Remove Money type, add money formatting for decimal type

* Fix typein/out functions to not be user-callable

VIEWS

* Allow psql \copy to allow delimiters

* Add a function to return the last inserted oid, for use in psql scripts

* Allow psql to print nulls as distinct from ""(?)

* PQrequestCancel() be able to terminate backend waiting for lock

MISC

a matching index

* Improve LIMIT processing by using index to limit rows processed

* Have optimizer take LIMIT into account when considering index scans

* Make index creation use psort code, because it is now faster(Vadim)

* Create more system table indexes for faster cache lookups

* fix indexscan() so it does leak memory by not requiring caller to free

* Improve _bt_binsrch() to handle equal keys better, remove _bt_firsteq()(Tom)

CACHE

* Cache most recent query plan(s?)

* Shared catalog cache, reduce lseek()'s by caching table size in shared area

* elog() flushes cache, try invalidating just entries from current xact,

perhaps using invalidation cache

MISC

* Allow compression of log and meta data

* Update pg_statistic table to remove operator column

* Make index creation use psort code, because it is now faster(Vadim)

* Allow char() not to use variable-sized header to reduce disk size

* Do async I/O to do better read-ahead of data

* Fix memory exhaustion when using many OR's

* Use mmap() rather than SYSV shared memory(?)

* Process const = const parts of OR clause in separate pass

* Make oid use oidin/oidout not int4in/int4out in pg_type.h

* Create more system table indexes for faster cache lookups

* Improve Subplan list handling

* Allow Subplans to use efficient joins(hash, merge) with upper variable

* use fmgr_info()/fmgr_faddr() instead of fmgr() calls in high-traffic

places, like GROUP BY, UNIQUE, index processing, etc.

* improve dynamic memory allocation by introducing tuple-context memory

allocation

* fix indexscan() so it does leak memory by not requiring caller to free

* fix memory leak in cache code when non-existant table is refer

* fix memory leak in cache code when non-existant table is referenced

* In WHERE x=3 AND x=y, add y=3

* pass atttypmod through parser in more cases(Bruce)

SOURCE CODE

-----------

*

*

* IDENTIFICATION

* $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.86 1999/07/04 04:55:59 momjian Exp $

* $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.87 1999/07/08 00:00:42 momjian Exp $

*

* HISTORY

* AUTHORDATEMAJOR EVENT

%nonassocNULL_P

%nonassocIS

%left'+' '-'

%left'*' '/' '%'

%left'*' '/' '%' '^'

%left'|'/* this is the relation union op, not logical or */

/* Unary Operators */

%right':'

{$$ = nconc( $1, lcons( makeString( "%"), $3)); }

| default_expr '*' default_expr

{$$ = nconc( $1, lcons( makeString( "*"), $3)); }

| default_expr '^' default_expr

{$$ = nconc( $1, lcons( makeString( "^"), $3)); }

| default_expr '=' default_expr

{elog(ERROR,"boolean expressions not supported in DEFAULT"); }

| default_expr '<' default_expr

{$$ = nconc( $1, lcons( makeString( "%"), $3)); }

| constraint_expr '*' constraint_expr

{$$ = nconc( $1, lcons( makeString( "*"), $3)); }

| constraint_expr '^' constraint_expr

{$$ = nconc( $1, lcons( makeString( "^"), $3)); }

| constraint_expr '=' constraint_expr

{$$ = nconc( $1, lcons( makeString( "="), $3)); }

| constraint_expr '<' constraint_expr

{$$ = doNegate($2); }

| '%' a_expr

{$$ = makeA_Expr(OP, "%", NULL, $2); }

| '^' a_expr

{$$ = makeA_Expr(OP, "^", NULL, $2); }

| a_expr '%'

{$$ = makeA_Expr(OP, "%", $1, NULL); }

| a_expr '^'

{$$ = makeA_Expr(OP, "^", $1, NULL); }

| a_expr '+' a_expr

{$$ = makeA_Expr(OP, "+", $1, $3); }

| a_expr '-' a_expr

{$$ = makeA_Expr(OP, "%", $1, $3); }

| a_expr '*' a_expr

{$$ = makeA_Expr(OP, "*", $1, $3); }

| a_expr '^' a_expr

{$$ = makeA_Expr(OP, "^", $1, $3); }

| a_expr '<' a_expr

{$$ = makeA_Expr(OP, "<", $1, $3); }

| a_expr '>' a_expr

{$$ = doNegate($2); }

| '%' b_expr

{$$ = makeA_Expr(OP, "%", NULL, $2); }

| '^' b_expr

{$$ = makeA_Expr(OP, "^", NULL, $2); }

| b_expr '%'

{$$ = makeA_Expr(OP, "%", $1, NULL); }

| b_expr '^'

{$$ = makeA_Expr(OP, "^", $1, NULL); }

| b_expr '+' b_expr

{$$ = makeA_Expr(OP, "+", $1, $3); }

| b_expr '-' b_expr

{$$ = makeA_Expr(OP, "/", $1, $3); }

| b_expr '%' b_expr

{$$ = makeA_Expr(OP, "%", $1, $3); }

| b_expr '^' b_expr

{$$ = makeA_Expr(OP, "^", $1, $3); }

| b_expr '*' b_expr

{$$ = makeA_Expr(OP, "*", $1, $3); }

| ':' b_expr

self[,()\[\].;$\:\+\-\*\/\%\<\>\=\|]

self[,()\[\].;$\:\+\-\*\/\%\^\<\>\=\|]

op_and_self[\~\!\@\#\^\&\|\`\?\$\:\+\-\*\/\%\<\>\=]

operator{op_and_self}+