X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 724B954CF8
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Tue,  1 Mar 2005 23:46:40 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 39443-02
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Tue,  1 Mar 2005 23:46:30 +0000 (GMT)
Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82])
	by svr1.postgresql.org (Postfix) with ESMTP id 47E9555773
	for <pgsql-docs@postgresql.org>; Tue,  1 Mar 2005 23:46:29 +0000 (GMT)
Received: from localhost (mailbox.samurai.com [205.207.28.82])
	by mailbox.samurai.com (Postfix) with ESMTP id CB49918CDE6;
	Tue,  1 Mar 2005 18:46:32 -0500 (EST)
Received: from mailbox.samurai.com ([205.207.28.82])
	by localhost (mailbox.samurai.com [205.207.28.82]) (amavisd-new,
	port 10024)
	with LMTP id 50774-01-4; Tue,  1 Mar 2005 18:46:31 -0500 (EST)
Received: from [61.88.101.19] (unknown [61.88.101.19])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mailbox.samurai.com (Postfix) with ESMTP id D316D18CDC9;
	Tue,  1 Mar 2005 18:46:29 -0500 (EST)
Message-ID: <4224FED2.8090706@samurai.com>
Date: Wed, 02 Mar 2005 10:46:26 +1100
From: Neil Conway <neilc@samurai.com>
User-Agent: Debian Thunderbird 1.0 (X11/20050116)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: pgsql-docs@postgresql.org
Subject: Re: question about markup
References: <200502282204.01773.xzilla@users.sourceforge.net>
In-Reply-To: <200502282204.01773.xzilla@users.sourceforge.net>
Content-Type: multipart/mixed; boundary="------------050603010306030004090101"
X-Virus-Scanned: by amavisd-new at mailbox.samurai.com
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.041 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200503/3
X-Sequence-Number: 2899

This is a multi-part message in MIME format.
--------------050603010306030004090101
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Robert Treat wrote:
> someone suggested that the insert command at the end of 
> http://wwwmaster.postgresql.org/docs/8.0/interactive/dml.html  would be 
> better if it were a link like the copy command is.  Is there some reason not 
> to make it a link?

No particular reason. I've applied the following patch to head; it makes 
the first reference to "INSERT" in that page an xref, as well as making 
a few other minor improvements.

> I notice most commands are not done this way. 

Yeah, there's not much point linking each and every reference to a SQL 
command.

-Neil


--------------050603010306030004090101
Content-Type: text/x-patch;
 name="dml_sgml_improv-1.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="dml_sgml_improv-1.patch"

Index: doc/src/sgml/dml.sgml
===================================================================
RCS file: /var/lib/cvs/pgsql/doc/src/sgml/dml.sgml,v
retrieving revision 1.10
diff -c -r1.10 dml.sgml
*** doc/src/sgml/dml.sgml	22 Jan 2005 22:56:35 -0000	1.10
--- doc/src/sgml/dml.sgml	1 Mar 2005 23:39:45 -0000
***************
*** 38,47 ****
    </para>
  
    <para>
!    To create a new row, use the <literal>INSERT</literal> command.
!    The command requires the table name and a value for each of the
!    columns of the table.  For example, consider the products table
!    from <xref linkend="ddl">:
  <programlisting>
  CREATE TABLE products (
      product_no integer,
--- 38,47 ----
    </para>
  
    <para>
!    To create a new row, use the <xref linkend="sql-insert"
!    xreflabel="sql-insert-title"> command.  The command requires the
!    table name and a value for each of the columns of the table.  For
!    example, consider the products table from <xref linkend="ddl">:
  <programlisting>
  CREATE TABLE products (
      product_no integer,
***************
*** 98,104 ****
      To do <quote>bulk loads</quote>, that is, inserting a lot of data,
      take a look at the <xref linkend="sql-copy"
      endterm="sql-copy-title"> command.  It is not as flexible as the
!     <command>INSERT</command> command, but is more efficient.
     </para>
    </tip>
   </sect1>
--- 98,106 ----
      To do <quote>bulk loads</quote>, that is, inserting a lot of data,
      take a look at the <xref linkend="sql-copy"
      endterm="sql-copy-title"> command.  It is not as flexible as the
!     <command>INSERT</command> command, but is more efficient. Refer to
!     <xref linkend="populate"> for more information on improving bulk
!     loading performance.
     </para>
    </tip>
   </sect1>
***************
*** 188,194 ****
  
    <para>
     You can update more than one column in an
!    <literal>UPDATE</literal> command by listing more than one
     assignment in the <literal>SET</literal> clause.  For example:
  <programlisting>
  UPDATE mytable SET a = 5, b = 3, c = 1 WHERE a &gt; 0;
--- 190,196 ----
  
    <para>
     You can update more than one column in an
!    <command>UPDATE</command> command by listing more than one
     assignment in the <literal>SET</literal> clause.  For example:
  <programlisting>
  UPDATE mytable SET a = 5, b = 3, c = 1 WHERE a &gt; 0;
***************
*** 222,230 ****
    </para>
  
    <para>
!    You use the <literal>DELETE</literal> command to remove rows; the
!    syntax is very similar to the <literal>UPDATE</literal> command.
!    For instance, to remove all rows from the products table that have a price of 10, use
  <programlisting>
  DELETE FROM products WHERE price = 10;
  </programlisting>
--- 224,234 ----
    </para>
  
    <para>
!    You use the <xref linkend="sql-delete"
!    xreflabel="sql-delete-title"> command to remove rows; the syntax is
!    very similar to the <command>UPDATE</command> command.  For
!    instance, to remove all rows from the products table that have a
!    price of 10, use
  <programlisting>
  DELETE FROM products WHERE price = 10;
  </programlisting>

--------------050603010306030004090101--