From 3c4447fd97ca15a2fca295571809611756894333 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Thu, 15 Jul 1999 16:31:16 +0000 Subject: [PATCH] Complete markup for docbook2man support. Fix synopsis info thanks to Yves.Martin@ensimag.imag.fr. --- doc/src/sgml/ref/set.sgml | 207 ++++++++++++-------------------------- 1 file changed, 65 insertions(+), 142 deletions(-) diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 3820ba7081..39aa7c6ea0 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -20,7 +20,7 @@ SET variable { TO | = } { 'value' | DEFAULT } SET TIME ZONE { 'timezone' | LOCAL | DEFAULT } -SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZED } +SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } @@ -34,9 +34,7 @@ SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZED } - -variable - + variable Settable global parameter. @@ -44,9 +42,7 @@ SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZED } - -value - + value New value of parameter. @@ -61,18 +57,14 @@ SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZED } - -CLIENT_ENCODING | NAMES - + CLIENT_ENCODING | NAMES Sets the multi-byte client encoding. Parameters are: - -value - + value Sets the multi-byte client encoding to @@ -83,9 +75,7 @@ CLIENT_ENCODING | NAMES - -DEFAULT - + DEFAULT Sets the multi-byte client encoding to the default value. @@ -102,9 +92,7 @@ DEFAULT - -DateStyle - + DateStyle Set the date/time representation style. Affects the output format, @@ -112,9 +100,7 @@ DateStyle - -ISO - + ISO use ISO 8601-style dates and times @@ -122,9 +108,7 @@ ISO - -SQL - + SQL use Oracle/Ingres-style dates and times @@ -132,9 +116,7 @@ SQL - -Postgres - + Postgres use traditional Postgres format @@ -142,9 +124,7 @@ Postgres - -European - + European use dd/mm/yyyy for numeric date representations. @@ -152,9 +132,7 @@ European - -NonEuropean - + NonEuropean use mm/dd/yyyy for numeric date representations. @@ -162,9 +140,7 @@ NonEuropean - -German - + German use dd.mm.yyyy for numeric date representations. @@ -172,9 +148,7 @@ German - -US - + US same as 'NonEuropean' @@ -182,9 +156,7 @@ US - -default - + DEFAULT restores the default values ('US,Postgres') @@ -227,18 +199,14 @@ default - -SERVER_ENCODING - + SERVER_ENCODING Sets the multi-byte server encoding - -value - + value Sets the multi-byte server encoding. @@ -247,9 +215,7 @@ SERVER_ENCODING - -DEFAULT - + DEFAULT Sets the multi-byte server encoding. @@ -265,9 +231,7 @@ DEFAULT - -TIMEZONE - + TIMEZONE The possible values for timezone depends on your operating @@ -279,9 +243,7 @@ TIMEZONE - -'PST8PDT' - + 'PST8PDT' set the timezone for California @@ -289,9 +251,7 @@ TIMEZONE - -'Portugal' - + 'Portugal' set time zone for Portugal. @@ -299,9 +259,7 @@ TIMEZONE - -'Europe/Rome' - + 'Europe/Rome' set time zone for Italy. @@ -309,9 +267,7 @@ TIMEZONE - -DEFAULT - + DEFAULT set time zone to your local timezone @@ -339,18 +295,14 @@ DEFAULT - -TRANSACTION ISOLATION LEVEL - + TRANSACTION ISOLATION LEVEL Sets the isolation level for the current transaction. - -READ COMMITTED - + READ COMMITTED The current transaction queries read only rows committed @@ -367,9 +319,7 @@ READ COMMITTED - -SERIALIZABLE - + SERIALIZABLE The current transaction queries read only rows committed @@ -394,18 +344,14 @@ SERIALIZABLE - -COST_HEAP - + COST_HEAP Sets the default cost of a heap scan for use by the optimizer. - -float4 - + float4 Set the cost of a heap scan to the specified floating point value. @@ -414,9 +360,7 @@ COST_HEAP - -DEFAULT - + DEFAULT Sets the cost of a heap scan to the default value. @@ -433,18 +377,14 @@ DEFAULT - -COST_INDEX - + COST_INDEX Sets the default cost of an index scan for use by the optimizer. - -float4 - + float4 Set the cost of an index scan to the specified floating point value. @@ -453,9 +393,7 @@ COST_INDEX - -DEFAULT - + DEFAULT Sets the cost of an index scan to the default value. @@ -473,18 +411,14 @@ DEFAULT - -GEQO - + GEQO Sets the threshold for using the genetic optimizer algorithm. - + - -ON - + ON enables the genetic optimizer algorithm @@ -492,10 +426,9 @@ ON + - -ON=# - + ON=# Takes an integer argument to enable the genetic optimizer algorithm @@ -504,10 +437,9 @@ ON=# + - -OFF - + OFF disables the genetic optimizer algorithm. @@ -515,9 +447,7 @@ OFF - -DEFAULT - + DEFAULT Equivalent to specifying SET GEQO='ON' @@ -546,9 +476,7 @@ DEFAULT - -KSQO - + KSQO Key Set Query Optimizer forces the query optimizer @@ -557,9 +485,7 @@ KSQO - -ON - + ON enables this optimization. @@ -568,9 +494,7 @@ ON - -OFF - + OFF disables this optimization. @@ -579,9 +503,7 @@ OFF - -DEFAULT - + DEFAULT Equivalent to specifying SET KSQO='OFF'. @@ -618,9 +540,9 @@ DEFAULT - -SET VARIABLE - + +SET VARIABLE + Message returned if successfully. @@ -629,9 +551,9 @@ DEFAULT - -WARN: Bad value for variable (value) - + +WARN: Bad value for variable (value) + If the command fails to set the specified variable. @@ -697,26 +619,26 @@ DEFAULT Set the style of date to ISO: - SET DATESTYLE TO 'ISO'; +SET DATESTYLE TO 'ISO'; Enable GEQO for queries with 4 or more tables: - SET GEQO ON=4; +SET GEQO ON=4; Set GEQO to default: - SET GEQO = DEFAULT; +SET GEQO = DEFAULT; Set the timezone for Berkeley, California: - SET TIME ZONE 'PST8PDT'; - SELECT CURRENT_TIMESTAMP AS today; +SET TIME ZONE 'PST8PDT'; +SELECT CURRENT_TIMESTAMP AS today; today ---------------------- @@ -726,8 +648,8 @@ DEFAULT Set the timezone for Italy: - SET TIME ZONE 'Europe/Rome'; - SELECT CURRENT_TIMESTAMP AS today; +SET TIME ZONE 'Europe/Rome'; +SELECT CURRENT_TIMESTAMP AS today; today ---------------------- @@ -751,17 +673,18 @@ DEFAULT SQL92 - There is no + There is no general SET variable - in SQL92 (except for SET TRANSACTION ISOLATION LEVEL). - + in SQL92 (with the exception of + SET TRANSACTION ISOLATION LEVEL). + The SQL92 syntax for SET TIME ZONE is slightly different, allowing only a single integer value for time zone specification: - - SET TIME ZONE { interval_value_expression | LOCAL } - + +SET TIME ZONE { interval_value_expression | LOCAL } + @@ -779,7 +702,7 @@ sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../reference.ced" sgml-exposed-tags:nil -sgml-local-catalogs:"/usr/lib/sgml/CATALOG" +sgml-local-catalogs:"/usr/lib/sgml/catalog" sgml-local-ecat-files:nil End: --> -- 2.40.0