diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2010-10-22 17:37:38 +0300 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2010-10-22 17:44:36 +0300 |
| commit | 143b8cbceec0d15dd5c747e2c45a4b0a762af6f0 (patch) | |
| tree | 8f39675b785b157b815cf96ca106133da15db89b /src/include | |
| parent | eda3a62f98a6d81727f82a9ae13718343549ca7d (diff) | |
Make OFF keyword unreserved. It's not hard to imagine wanting to use 'off'
as a variable or column name, and it's not reserved in recent versions of
the SQL spec either. This became particularly annoying in 9.0, before that
PL/pgSQL replaced variable names in queries with parameter markers, so
it was possible to use OFF and many other backend parser keywords as
variable names. Because of that, backpatch to 9.0.
Diffstat (limited to 'src/include')
| -rw-r--r-- | src/include/parser/kwlist.h | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/include/parser/kwlist.h b/src/include/parser/kwlist.h index 5065bd609e9..ad835d9a7d3 100644 --- a/src/include/parser/kwlist.h +++ b/src/include/parser/kwlist.h @@ -260,7 +260,7 @@ PG_KEYWORD("nulls", NULLS_P, UNRESERVED_KEYWORD) PG_KEYWORD("numeric", NUMERIC, COL_NAME_KEYWORD) PG_KEYWORD("object", OBJECT_P, UNRESERVED_KEYWORD) PG_KEYWORD("of", OF, UNRESERVED_KEYWORD) -PG_KEYWORD("off", OFF, RESERVED_KEYWORD) +PG_KEYWORD("off", OFF, UNRESERVED_KEYWORD) PG_KEYWORD("offset", OFFSET, RESERVED_KEYWORD) PG_KEYWORD("oids", OIDS, UNRESERVED_KEYWORD) PG_KEYWORD("on", ON, RESERVED_KEYWORD) |