minor doc work - Mailing list pgsql-patches
From | Neil Conway |
---|---|
Subject | minor doc work |
Date | |
Msg-id | 404A7C07.5030002@samurai.com Whole thread Raw |
Responses |
Re: minor doc work
|
List | pgsql-patches |
I've applied the two attached minor documentation patches to HEAD. Each patch makes a few minor improvements to a particular section of the docs (the discussion of IS NULL and the discussion of SET, respectively). Cheers, Neil Index: doc/src/sgml/func.sgml =================================================================== RCS file: /var/lib/cvs/pgsql-server/doc/src/sgml/func.sgml,v retrieving revision 1.191 diff -c -r1.191 func.sgml *** a/doc/src/sgml/func.sgml 5 Mar 2004 02:41:14 -0000 1.191 --- b/doc/src/sgml/func.sgml 5 Mar 2004 19:50:42 -0000 *************** *** 301,320 **** <literal><replaceable>expression</replaceable> = NULL</literal> because <literal>NULL</> is not <quote>equal to</quote> <literal>NULL</>. (The null value represents an unknown value, ! and it is not known whether two unknown values are equal.) </para> <para> ! Some applications may (incorrectly) require that <literal><replaceable>expression</replaceable> = NULL</literal> returns true if <replaceable>expression</replaceable> evaluates to ! the null value. To support these applications, the run-time option ! <varname>transform_null_equals</varname> can be turned on (e.g., ! <literal>SET transform_null_equals TO ON;</literal>). ! <productname>PostgreSQL</productname> will then convert ! <literal>x = NULL</literal> clauses to ! <literal>x IS NULL</literal>. This was ! the default behavior in releases 6.5 through 7.1. </para> <para> --- 301,322 ---- <literal><replaceable>expression</replaceable> = NULL</literal> because <literal>NULL</> is not <quote>equal to</quote> <literal>NULL</>. (The null value represents an unknown value, ! and it is not known whether two unknown values are equal.) This ! behavior conforms to the SQL standard. </para> <para> ! Some applications may expect that <literal><replaceable>expression</replaceable> = NULL</literal> returns true if <replaceable>expression</replaceable> evaluates to ! the null value. It is highly recommended that these applications ! be modified to comply with the SQL standard. However, if that ! cannot be done the <varname>transform_null_equals</varname> ! configuration variable is available. If it is enabled, ! <productname>PostgreSQL</productname> will convert <literal>x = ! NULL</literal> clauses to <literal>x IS NULL</literal>. This was ! the default behavior in <productname>PostgreSQL</productname> ! releases 6.5 through 7.1. </para> <para> Index: doc/src/sgml/runtime.sgml =================================================================== RCS file: /var/lib/cvs/pgsql-server/doc/src/sgml/runtime.sgml,v retrieving revision 1.244 diff -c -r1.244 runtime.sgml *** a/doc/src/sgml/runtime.sgml 5 Mar 2004 23:16:17 -0000 1.244 --- b/doc/src/sgml/runtime.sgml 7 Mar 2004 00:59:19 -0000 *************** *** 541,548 **** SET ENABLE_SEQSCAN TO OFF; </screen> If <command>SET</> is allowed, it overrides all other sources of ! values for the parameter. Superusers are allowed to <command>SET</> ! more values than ordinary users. </para> <para> --- 541,551 ---- SET ENABLE_SEQSCAN TO OFF; </screen> If <command>SET</> is allowed, it overrides all other sources of ! values for the parameter. Superusers are allowed to ! <command>SET</> more values than ordinary users. Some parameters ! cannot be <command>SET</command> even by superusers: for example, ! if they control behavior that cannot reasonably be changed without ! restarting <productname>PostgreSQL</productname>. </para> <para>
pgsql-patches by date: