~ubuntu-branches/ubuntu/lucid/postgresql-8.4/lucid-proposed

« back to all changes in this revision

Viewing changes to doc/src/sgml/dml.sgml

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2009-07-11 16:59:35 UTC
  • mfrom: (5.1.1 karmic)
  • Revision ID: james.westby@ubuntu.com-20090711165935-jfwin6gfrxf0gfsi
Tags: 8.4.0-2
* debian/libpq-dev.install: Ship catalog/genbki.h. (Closes: #536139)
* debian/rules: Drop --enable-cassert for final release.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
<!-- $PostgreSQL: pgsql/doc/src/sgml/dml.sgml,v 1.18 2009/04/27 16:27:35 momjian Exp $ -->
 
1
<!-- $PostgreSQL: pgsql/doc/src/sgml/dml.sgml,v 1.20 2009/06/23 20:33:25 tgl Exp $ -->
2
2
 
3
3
<chapter id="dml">
4
4
 <title>Data Manipulation</title>
134
134
  </para>
135
135
 
136
136
  <para>
137
 
   To perform an update, you need three pieces of information:
 
137
   To update existing rows, use the <xref linkend="sql-update"
 
138
   endterm="sql-update-title"> command.  This requires
 
139
   three pieces of information:
138
140
   <orderedlist spacing="compact">
139
141
    <listitem>
140
142
     <para>The name of the table and column to update</para>
248
250
<programlisting>
249
251
DELETE FROM products;
250
252
</programlisting>
251
 
   then all rows in the table will be deleted!  (<xref
252
 
   linkend="sql-truncate" endterm="sql-truncate-title"> can also be used
253
 
   to delete all rows.)
254
 
   Caveat programmer.
 
253
   then all rows in the table will be deleted!  Caveat programmer.
255
254
  </para>
256
255
 </sect1>
257
256
</chapter>