← Back to branch summary

~ubuntu-branches/debian/sid/postgresql-9.3/sid

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/typeconv.html

  • Committer: Package Import Robot
  • Author(s): Martin Pitt
  • Date: 2013-05-08 05:39:52 UTC
  • Revision ID: package-import@ubuntu.com-20130508053952-1j7uilp7mjtrvq8q
Tags: upstream-9.3~beta1
Import upstream version 9.3~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/typeconv.html
 
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
2
<HTML
 
3
><HEAD
 
4
><TITLE
 
5
>Type Conversion</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REV="MADE"
 
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
 
11
REL="HOME"
 
12
TITLE="PostgreSQL 9.3beta1 Documentation"
 
13
HREF="index.html"><LINK
 
14
REL="UP"
 
15
TITLE="The SQL Language"
 
16
HREF="sql.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="Event Trigger Functions"
 
19
HREF="functions-event-triggers.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="Overview"
 
22
HREF="typeconv-overview.html"><LINK
 
23
REL="STYLESHEET"
 
24
TYPE="text/css"
 
25
HREF="stylesheet.css"><META
 
26
HTTP-EQUIV="Content-Type"
 
27
CONTENT="text/html; charset=ISO-8859-1"><META
 
28
NAME="creation"
 
29
CONTENT="2013-05-06T21:00:50"></HEAD
 
30
><BODY
 
31
CLASS="CHAPTER"
 
32
><DIV
 
33
CLASS="NAVHEADER"
 
34
><TABLE
 
35
SUMMARY="Header navigation table"
 
36
WIDTH="100%"
 
37
BORDER="0"
 
38
CELLPADDING="0"
 
39
CELLSPACING="0"
 
40
><TR
 
41
><TH
 
42
COLSPAN="5"
 
43
ALIGN="center"
 
44
VALIGN="bottom"
 
45
><A
 
46
HREF="index.html"
 
47
>PostgreSQL 9.3beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="Event Trigger Functions"
 
57
HREF="functions-event-triggers.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
HREF="sql.html"
 
67
ACCESSKEY="U"
 
68
>Up</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
></TD
 
75
><TD
 
76
WIDTH="20%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="Overview"
 
81
HREF="typeconv-overview.html"
 
82
ACCESSKEY="N"
 
83
>Next</A
 
84
></TD
 
85
></TR
 
86
></TABLE
 
87
><HR
 
88
ALIGN="LEFT"
 
89
WIDTH="100%"></DIV
 
90
><DIV
 
91
CLASS="CHAPTER"
 
92
><H1
 
93
><A
 
94
NAME="TYPECONV"
 
95
></A
 
96
>Chapter 10. Type Conversion</H1
 
97
><DIV
 
98
CLASS="TOC"
 
99
><DL
 
100
><DT
 
101
><B
 
102
>Table of Contents</B
 
103
></DT
 
104
><DT
 
105
>10.1. <A
 
106
HREF="typeconv-overview.html"
 
107
>Overview</A
 
108
></DT
 
109
><DT
 
110
>10.2. <A
 
111
HREF="typeconv-oper.html"
 
112
>Operators</A
 
113
></DT
 
114
><DT
 
115
>10.3. <A
 
116
HREF="typeconv-func.html"
 
117
>Functions</A
 
118
></DT
 
119
><DT
 
120
>10.4. <A
 
121
HREF="typeconv-query.html"
 
122
>Value Storage</A
 
123
></DT
 
124
><DT
 
125
>10.5. <A
 
126
HREF="typeconv-union-case.html"
 
127
><TT
 
128
CLASS="LITERAL"
 
129
>UNION</TT
 
130
>, <TT
 
131
CLASS="LITERAL"
 
132
>CASE</TT
 
133
>, and Related Constructs</A
 
134
></DT
 
135
></DL
 
136
></DIV
 
137
><P
 
138
><ACRONYM
 
139
CLASS="ACRONYM"
 
140
>SQL</ACRONYM
 
141
> statements can, intentionally or not, require
 
142
the mixing of different data types in the same expression.
 
143
<SPAN
 
144
CLASS="PRODUCTNAME"
 
145
>PostgreSQL</SPAN
 
146
> has extensive facilities for
 
147
evaluating mixed-type expressions.</P
 
148
><P
 
149
>In many cases a user does not need
 
150
to understand the details of the type conversion mechanism.
 
151
However, implicit conversions done by <SPAN
 
152
CLASS="PRODUCTNAME"
 
153
>PostgreSQL</SPAN
 
154
>
 
155
can affect the results of a query.  When necessary, these results
 
156
can be tailored by using <SPAN
 
157
CLASS="emphasis"
 
158
><I
 
159
CLASS="EMPHASIS"
 
160
>explicit</I
 
161
></SPAN
 
162
> type conversion.</P
 
163
><P
 
164
>This chapter introduces the <SPAN
 
165
CLASS="PRODUCTNAME"
 
166
>PostgreSQL</SPAN
 
167
>
 
168
type conversion mechanisms and conventions.
 
169
Refer to the relevant sections in <A
 
170
HREF="datatype.html"
 
171
>Chapter 8</A
 
172
> and <A
 
173
HREF="functions.html"
 
174
>Chapter 9</A
 
175
>
 
176
for more information on specific data types and allowed functions and
 
177
operators.</P
 
178
></DIV
 
179
><DIV
 
180
CLASS="NAVFOOTER"
 
181
><HR
 
182
ALIGN="LEFT"
 
183
WIDTH="100%"><TABLE
 
184
SUMMARY="Footer navigation table"
 
185
WIDTH="100%"
 
186
BORDER="0"
 
187
CELLPADDING="0"
 
188
CELLSPACING="0"
 
189
><TR
 
190
><TD
 
191
WIDTH="33%"
 
192
ALIGN="left"
 
193
VALIGN="top"
 
194
><A
 
195
HREF="functions-event-triggers.html"
 
196
ACCESSKEY="P"
 
197
>Prev</A
 
198
></TD
 
199
><TD
 
200
WIDTH="34%"
 
201
ALIGN="center"
 
202
VALIGN="top"
 
203
><A
 
204
HREF="index.html"
 
205
ACCESSKEY="H"
 
206
>Home</A
 
207
></TD
 
208
><TD
 
209
WIDTH="33%"
 
210
ALIGN="right"
 
211
VALIGN="top"
 
212
><A
 
213
HREF="typeconv-overview.html"
 
214
ACCESSKEY="N"
 
215
>Next</A
 
216
></TD
 
217
></TR
 
218
><TR
 
219
><TD
 
220
WIDTH="33%"
 
221
ALIGN="left"
 
222
VALIGN="top"
 
223
>Event Trigger Functions</TD
 
224
><TD
 
225
WIDTH="34%"
 
226
ALIGN="center"
 
227
VALIGN="top"
 
228
><A
 
229
HREF="sql.html"
 
230
ACCESSKEY="U"
 
231
>Up</A
 
232
></TD
 
233
><TD
 
234
WIDTH="33%"
 
235
ALIGN="right"
 
236
VALIGN="top"
 
237
>Overview</TD
 
238
></TR
 
239
></TABLE
 
240
></DIV
 
241
></BODY
 
242
></HTML
 
243
>
 
 
b'\\ No newline at end of file'