diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-01-20 22:46:06 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-01-20 22:46:06 +0000 |
| commit | 0f8a3135088519f60946a1f8d8f75cfe1e9b55b8 (patch) | |
| tree | 7d74c82546c26d684b54aaf4a5bbdf3b08da74cc | |
| parent | 18f7a8e262f00ddadc7f34b603e15d02ecb44096 (diff) | |
| download | postgresql-0f8a3135088519f60946a1f8d8f75cfe1e9b55b8.tar.gz postgresql-0f8a3135088519f60946a1f8d8f75cfe1e9b55b8.zip | |
Remove no-longer-relevant note about forcing the type of an integer
constant. Per Kris Jurka.
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 24 |
1 files changed, 1 insertions, 23 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 8d24f146547..7bbe676a9a1 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.139 2003/12/21 04:34:35 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.140 2004/01/20 22:46:06 tgl Exp $ --> <chapter id="datatype"> @@ -437,28 +437,6 @@ $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.139 2003/12/21 04:34:35 momjia other <acronym>SQL</acronym> database systems. </para> - <note> - <para> - If you have a column of type <type>smallint</type> or - <type>bigint</type> with an index, you may encounter problems - getting the system to use that index. For instance, a clause of - the form -<programlisting> -... WHERE smallint_column = 42 -</programlisting> - will not use an index, because the system assigns type - <type>integer</type> to the constant 42, and - <productname>PostgreSQL</productname> currently - cannot use an index when two different data types are involved. A - workaround is to single-quote the constant, thus: -<programlisting> -... WHERE smallint_column = '42' -</programlisting> - This will cause the system to delay type resolution and will - assign the right type to the constant. - </para> - </note> - </sect2> <sect2 id="datatype-numeric-decimal"> |