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:

Previous
From: "Lee Kindness"
Date:
Subject: Re: Update tests & memory leak fix
Next
From: John Siracusa
Date:
Subject: Re: [PERFORM] Feature request: smarter use of conditional indexes