summaryrefslogtreecommitdiff
path: root/doc/src/sgml/citext.sgml
diff options
context:
space:
mode:
authorPeter Eisentraut2010-07-29 19:34:41 +0000
committerPeter Eisentraut2010-07-29 19:34:41 +0000
commit66424a284879b5e0d456a1c7c1ec06b0b918a798 (patch)
treeec11d97b4bb1c04fc1ace6920fb1f38d612342eb /doc/src/sgml/citext.sgml
parent984d56b80f5a945db2bfa80499b5ed913848242b (diff)
Fix indentation of verbatim block elements
Block elements with verbatim formatting (literallayout, programlisting, screen, synopsis) should be aligned at column 0 independent of the surrounding SGML, because whitespace is significant, and indenting them creates erratic whitespace in the output. The CSS stylesheets already take care of indenting the output. Assorted markup improvements to go along with it.
Diffstat (limited to 'doc/src/sgml/citext.sgml')
-rw-r--r--doc/src/sgml/citext.sgml32
1 files changed, 16 insertions, 16 deletions
diff --git a/doc/src/sgml/citext.sgml b/doc/src/sgml/citext.sgml
index 49b09898156..28c5043183c 100644
--- a/doc/src/sgml/citext.sgml
+++ b/doc/src/sgml/citext.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/citext.sgml,v 1.4 2010/06/29 22:29:13 momjian Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/citext.sgml,v 1.5 2010/07/29 19:34:40 petere Exp $ -->
<sect1 id="citext">
<title>citext</title>
@@ -22,9 +22,9 @@
in <productname>PostgreSQL</> has been to use the <function>lower</>
function when comparing values, for example
- <programlisting>
- SELECT * FROM tab WHERE lower(col) = LOWER(?);
- </programlisting>
+<programlisting>
+SELECT * FROM tab WHERE lower(col) = LOWER(?);
+</programlisting>
</para>
<para>
@@ -74,20 +74,20 @@
<para>
Here's a simple example of usage:
- <programlisting>
- CREATE TABLE users (
- nick CITEXT PRIMARY KEY,
- pass TEXT NOT NULL
- );
+<programlisting>
+CREATE TABLE users (
+ nick CITEXT PRIMARY KEY,
+ pass TEXT NOT NULL
+);
- INSERT INTO users VALUES ( 'larry', md5(random()::text) );
- INSERT INTO users VALUES ( 'Tom', md5(random()::text) );
- INSERT INTO users VALUES ( 'Damian', md5(random()::text) );
- INSERT INTO users VALUES ( 'NEAL', md5(random()::text) );
- INSERT INTO users VALUES ( 'Bj&oslash;rn', md5(random()::text) );
+INSERT INTO users VALUES ( 'larry', md5(random()::text) );
+INSERT INTO users VALUES ( 'Tom', md5(random()::text) );
+INSERT INTO users VALUES ( 'Damian', md5(random()::text) );
+INSERT INTO users VALUES ( 'NEAL', md5(random()::text) );
+INSERT INTO users VALUES ( 'Bj&oslash;rn', md5(random()::text) );
- SELECT * FROM users WHERE nick = 'Larry';
- </programlisting>
+SELECT * FROM users WHERE nick = 'Larry';
+</programlisting>
The <command>SELECT</> statement will return one tuple, even though
the <structfield>nick</> column was set to <quote>larry</> and the query