From d810338d29bff178101e72c810c9dcfa3223c6c0 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Wed, 29 Sep 1999 05:22:25 +0000 Subject: [PATCH] Add a few items to the reserved keyword lists. Clarify information on implicitly-typed constants. --- doc/src/sgml/syntax.sgml | 40 ++++++++++++++++++++++------------------ 1 file changed, 22 insertions(+), 18 deletions(-) diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index b70841523f..027377853f 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -181,12 +181,13 @@ ALLOCATE ARE ASSERTION AT AUTHORIZATION AVG BIT BIT_LENGTH CASCADED CATALOG COLLATION CONNECT CONNECTION CONSTRAINTS CONTINUE CONVERT CORRESPONDING COUNT -DATE DEALLOCATE DEC DESCRIBE DESCRIPTOR DIAGNOSTICS DISCONNECT DOMAIN +DATE DEALLOCATE DEC DEFERRABLE DEFERRED DESCRIBE DESCRIPTOR + DIAGNOSTICS DISCONNECT DOMAIN END-EXEC ESCAPE EXCEPT EXCEPTION EXEC EXTERNAL FIRST FOUND GET GO GOTO -IDENTITY IMMEDIATE INDICATOR INITIALLY INPUT INTERSECT ISOLATION -LAST LEVEL LOWER +IDENTITY IMMEDIATE INDICATOR INITIALLY INPUT INTERSECT +LAST LOWER MAX MIN MODULE OCTET_LENGTH OPEN OUTPUT OVERLAPS PREPARE PRESERVE @@ -250,9 +251,9 @@ VALID VERSION ABSOLUTE ACTION DAY HOUR -INSENSITIVE +INSENSITIVE ISOLATION KEY -LANGUAGE +LANGUAGE LEVEL MATCH MINUTE MONTH NEXT OF ONLY OPTION @@ -283,22 +284,21 @@ COMMITTED SERIALIZABLE TYPE ADA C CATALOG_NAME CHARACTER_SET_CATALOG CHARACTER_SET_NAME -CHARACTER_SET_SCHEMA CLASS_ORIGIN COBOL COLLATION_CATALOG -COLLATION_NAME COLLATION_SCHEMA COLUMN_NAME -COMMAND_FUNCTION CONDITION_NUMBER -CONNECTION_NAME CONSTRAINT_CATALOG CONSTRAINT_NAME -CONSTRAINT_SCHEMA CURSOR_NAME + CHARACTER_SET_SCHEMA CLASS_ORIGIN COBOL COLLATION_CATALOG + COLLATION_NAME COLLATION_SCHEMA COLUMN_NAME + COMMAND_FUNCTION CONDITION_NUMBER + CONNECTION_NAME CONSTRAINT_CATALOG CONSTRAINT_NAME + CONSTRAINT_SCHEMA CURSOR_NAME DATA DATE_TIME_INTERVAL_CODE DATE_TIME_INTERVAL_PRECISION -DYNAMIC_FUNCTION + DYNAMIC_FUNCTION FORTRAN LENGTH MESSAGE_LENGTH MESSAGE_OCTET_LENGTH MORE MUMPS NAME NULLABLE NUMBER PAD PASCAL PLI REPEATABLE RETURNED_LENGTH RETURNED_OCTET_LENGTH -RETURNED_SQLSTATE ROW_COUNT -SCALE SCHEMA_NAME SERVER_NAME SPACE -SUBCLASS_ORIGIN + RETURNED_SQLSTATE ROW_COUNT +SCALE SCHEMA_NAME SERVER_NAME SPACE SUBCLASS_ORIGIN TABLE_NAME UNCOMMITTED UNNAMED @@ -354,9 +354,13 @@ We also support C-style block comments, e.g.: Constants - There are six types of - constants - for use in SQL. They are described below. + There are three implicitly typed constants + for use in Postgres: strings, integers, + and floating point numbers. Constants can + also be specified with explicit types, which can enable more + accurate representation and more efficient handling by the + backend. The implicit constants are described below; explicit + constants are discussed afterwards. @@ -445,7 +449,7 @@ float4 '1.23' -- string style A constant of an arbitrary - type can be entered using the notations: + type can be entered using any one of the following notations: type 'string' -- 2.40.0