aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/typeconv.sgml
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2002-11-11 20:14:04 +0000
committerPeter Eisentraut <peter_e@gmx.net>2002-11-11 20:14:04 +0000
commit1b342df00af318055a1cf432c3eaa3b74347df39 (patch)
tree2f61d5b4c76b30bbe9130e99ec999b3676392128 /doc/src/sgml/typeconv.sgml
parentb3279066830d88bb4bf02a765229b23dbadf4648 (diff)
downloadpostgresql-1b342df00af318055a1cf432c3eaa3b74347df39.tar.gz
postgresql-1b342df00af318055a1cf432c3eaa3b74347df39.zip
Merge documentation updates from 7.3 branch.
Diffstat (limited to 'doc/src/sgml/typeconv.sgml')
-rw-r--r--doc/src/sgml/typeconv.sgml24
1 files changed, 10 insertions, 14 deletions
diff --git a/doc/src/sgml/typeconv.sgml b/doc/src/sgml/typeconv.sgml
index e6ff564be96..e0a330daeff 100644
--- a/doc/src/sgml/typeconv.sgml
+++ b/doc/src/sgml/typeconv.sgml
@@ -1,9 +1,6 @@
<chapter Id="typeconv">
<title>Type Conversion</title>
- <sect1 id="typeconv-intro">
- <title>Introduction</title>
-
<para>
<acronym>SQL</acronym> queries can, intentionally or not, require
mixing of different data types in the same expression.
@@ -29,10 +26,9 @@ operators.
</para>
<para>
-The <citetitle>Programmer's Guide</citetitle> has more details on the exact algorithms used for
+The &cite-programmer; has more details on the exact algorithms used for
implicit type conversion and coercion.
</para>
- </sect1>
<sect1 id="typeconv-overview">
<title>Overview</title>
@@ -41,7 +37,7 @@ implicit type conversion and coercion.
<acronym>SQL</acronym> is a strongly typed language. That is, every data item
has an associated data type which determines its behavior and allowed usage.
<productname>PostgreSQL</productname> has an extensible type system that is
-much more general and flexible than other <acronym>RDBMS</acronym> implementations.
+much more general and flexible than other <acronym>SQL</acronym> implementations.
Hence, most type conversion behavior in <productname>PostgreSQL</productname>
should be governed by general rules rather than by <foreignphrase>ad hoc</> heuristics, to allow
mixed-type expressions to be meaningful even with user-defined types.
@@ -142,13 +138,13 @@ conventions for the <acronym>SQL</acronym> standard native types such as
</para>
<para>
-The <productname>PostgreSQL</productname> parser uses the convention that all
-type conversion functions take a single argument of the source type and are
-named with the same name as the target type. Any function meeting these
-criteria is considered to be a valid conversion function, and may be used
-by the parser as such. This simple assumption gives the parser the power
-to explore type conversion possibilities without hardcoding, allowing
-extended user-defined types to use these same features transparently.
+The system catalogs store information about which conversions, called
+<firstterm>casts</firstterm>, between data types are valid, and how to
+perform those conversions. Additional casts can be added by the user
+with the <command>CREATE CAST</command> command. (This is usually
+done in conjunction with defining new data types. The set of casts
+between the built-in types has been carefully crafted and should not
+be altered.)
</para>
<para>
@@ -169,7 +165,7 @@ types.
<para>
All type conversion rules are designed with several principles in mind:
-<itemizedlist mark="bullet" spacing="compact">
+<itemizedlist>
<listitem>
<para>
Implicit conversions should never have surprising or unpredictable outcomes.