diff options
Diffstat (limited to 'doc/src/sgml/ref/delete.sgml')
| -rw-r--r-- | doc/src/sgml/ref/delete.sgml | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/doc/src/sgml/ref/delete.sgml b/doc/src/sgml/ref/delete.sgml index c27a4b9a013..f53b87280df 100644 --- a/doc/src/sgml/ref/delete.sgml +++ b/doc/src/sgml/ref/delete.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/delete.sgml,v 1.9 1999/10/04 04:37:46 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/delete.sgml,v 1.10 2000/03/26 18:32:27 petere Exp $ Postgres documentation --> @@ -131,33 +131,33 @@ DELETE <replaceable class="parameter">count</replaceable> </title> <para> Remove all films but musicals: - <programlisting> +<programlisting> DELETE FROM films WHERE kind <> 'Musical'; SELECT * FROM films; - <computeroutput> -code |title |did| date_prod|kind |len ------+-------------------------+---+----------+----------+------ -UA501|West Side Story |105|1961-01-03|Musical | 02:32 -TC901|The King and I |109|1956-08-11|Musical | 02:13 -WD101|Bed Knobs and Broomsticks|111| |Musical | 01:57 +<computeroutput> + code | title | did | date_prod | kind | len +-------+---------------------------+-----+------------+---------+------- + UA501 | West Side Story | 105 | 1961-01-03 | Musical | 02:32 + TC901 | The King and I | 109 | 1956-08-11 | Musical | 02:13 + WD101 | Bed Knobs and Broomsticks | 111 | | Musical | 01:57 (3 rows) - </computeroutput> - </programlisting> +</computeroutput> +</programlisting> </para> <para> Clear the table <literal>films</literal>: - <programlisting> +<programlisting> DELETE FROM films; SELECT * FROM films; - <computeroutput> -code|title|did|date_prod|kind|len -----+-----+---+---------+----+--- +<computeroutput> + code | title | did | date_prod | kind | len +------+-------+-----+-----------+------+----- (0 rows) - </computeroutput> - </programlisting> +</computeroutput> +</programlisting> </para> </refsect1> |