|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.170 2006/08/2100:57:23 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.171 2006/08/2116:23:46 tgl Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="datatype"> |
4 | 4 | <title id="datatype-title">Data Types</title> |
@@ -2294,19 +2294,6 @@ SELECT * FROM test1 WHERE a; |
2294 | 2294 | <literal>t</literal> and <literal>f</literal>. |
2295 | 2295 | </para> |
2296 | 2296 |
|
2297 | | - <tip> |
2298 | | - <para> |
2299 | | - Values of the <type>boolean</type> type cannot be cast directly |
2300 | | - to other types (e.g., <literal>CAST |
2301 | | - (<replaceable>boolval</replaceable> AS integer)</literal> does |
2302 | | - not work). This can be accomplished using the |
2303 | | - <literal>CASE</literal> expression: <literal>CASE WHEN |
2304 | | - <replaceable>boolval</replaceable> THEN 'value if true' ELSE |
2305 | | - 'value if false' END</literal>. See <xref |
2306 | | - linkend="functions-conditional">. |
2307 | | - </para> |
2308 | | - </tip> |
2309 | | - |
2310 | 2297 | <para> |
2311 | 2298 | <type>boolean</type> uses 1 byte of storage. |
2312 | 2299 | </para> |
|