diff options
| author | Bruce Momjian <bruce@momjian.us> | 1999-03-14 05:15:08 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1999-03-14 05:15:08 +0000 |
| commit | d13fe2900042a8d07c24235ede1892ff171c9f0f (patch) | |
| tree | 6e54dcbebc922908880d2a6d8d84c7753d3a688b /src | |
| parent | fd80c102fa9f265b9ba5f24f0f0b2bd7c934991b (diff) | |
| download | postgresql-d13fe2900042a8d07c24235ede1892ff171c9f0f.tar.gz postgresql-d13fe2900042a8d07c24235ede1892ff171c9f0f.zip | |
I have a problem with Access97 not working properly when entering new
records using a sub form, i.e. entering a new order/orderlines or master
and
detail tables. The problem is caused by a SQL statement that Access97
makes
involving NULL. The syntax that fails is "column_name" = NULL. The
following attachment was provided by -Jose'-. It contains a very small
enhancement to gram.y that will allow Access97 to work properly with sub
forms. Can this enhancement be added to release 6.5?
<<gram.patch>>
Thanks, Michael
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/parser/gram.c | 2 | ||||
| -rw-r--r-- | src/backend/parser/gram.y | 4 |
2 files changed, 4 insertions, 2 deletions
diff --git a/src/backend/parser/gram.c b/src/backend/parser/gram.c index e2e914239c5..3d090fed1c6 100644 --- a/src/backend/parser/gram.c +++ b/src/backend/parser/gram.c @@ -242,7 +242,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/parser/Attic/gram.c,v 2.76 1999/03/07 03:34:06 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/parser/Attic/gram.c,v 2.77 1999/03/14 05:14:59 momjian Exp $ * * HISTORY * AUTHOR DATE MAJOR EVENT diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y index 7afc2d90075..a94adbb00a5 100644 --- a/src/backend/parser/gram.y +++ b/src/backend/parser/gram.y @@ -10,7 +10,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.58 1999/03/07 03:34:10 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.59 1999/03/14 05:15:08 momjian Exp $ * * HISTORY * AUTHOR DATE MAJOR EVENT @@ -3702,6 +3702,8 @@ a_expr: attr opt_indirection { $$ = makeA_Expr(OP, "<", $1, $3); } | a_expr '>' a_expr { $$ = makeA_Expr(OP, ">", $1, $3); } + | a_expr '=' NULL_P + { $$ = makeA_Expr(ISNULL, NULL, $1, NULL); } | a_expr '=' a_expr { $$ = makeA_Expr(OP, "=", $1, $3); } | ':' a_expr |