← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/sql-select.html

  • Committer: Package Import Robot
  • Author(s): Martin Pitt
  • Date: 2013-02-05 18:13:52 UTC
  • mfrom: (1.1.10) (10.1.5 oneiric-proposed)
  • Revision ID: package-import@ubuntu.com-20130205181352-3kw4f94ilqklzm7c
Tags: 9.1.8-0ubuntu11.10
https://launchpad.net/bugs/1116336
* New upstream security/bug fix release: (LP: #1116336)
  - Prevent execution of enum_recv from SQL
    The function was misdeclared, allowing a simple SQL command to crash the
    server.  In principle an attacker might be able to use it to examine the
    contents of server memory.  Our thanks to Sumit Soni (via Secunia SVCRP)
    for reporting this issue. (CVE-2013-0255)
  - See HISTORY/changelog.gz for the other bug fixes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/sql-select.html
9
9
REV="MADE"
10
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
11
11
REL="HOME"
12
 
TITLE="PostgreSQL 9.1.5 Documentation"
 
12
TITLE="PostgreSQL 9.1.8 Documentation"
13
13
HREF="index.html"><LINK
14
14
REL="UP"
15
15
TITLE="SQL Commands"
26
26
HTTP-EQUIV="Content-Type"
27
27
CONTENT="text/html; charset=ISO-8859-1"><META
28
28
NAME="creation"
29
 
CONTENT="2012-08-14T22:55:48"></HEAD
 
29
CONTENT="2013-02-04T21:38:53"></HEAD
30
30
><BODY
31
31
CLASS="REFENTRY"
32
32
><DIV
44
44
VALIGN="bottom"
45
45
><A
46
46
HREF="index.html"
47
 
>PostgreSQL 9.1.5 Documentation</A
 
47
>PostgreSQL 9.1.8 Documentation</A
48
48
></TH
49
49
></TR
50
50
><TR
95
95
><DIV
96
96
CLASS="REFNAMEDIV"
97
97
><A
98
 
NAME="AEN74272"
 
98
NAME="AEN74308"
99
99
></A
100
100
><H2
101
101
>Name</H2
103
103
><DIV
104
104
CLASS="REFSYNOPSISDIV"
105
105
><A
106
 
NAME="AEN74284"
 
106
NAME="AEN74320"
107
107
></A
108
108
><H2
109
109
>Synopsis</H2
394
394
><DIV
395
395
CLASS="REFSECT1"
396
396
><A
397
 
NAME="AEN74336"
 
397
NAME="AEN74372"
398
398
></A
399
399
><H2
400
400
>Description</H2
738
738
><DIV
739
739
CLASS="REFSECT1"
740
740
><A
741
 
NAME="AEN74416"
 
741
NAME="AEN74452"
742
742
></A
743
743
><H2
744
744
>Parameters</H2
968
968
></DT
969
969
><DD
970
970
><P
971
 
>        The name (optionally schema-qualified) of an existing table or
972
 
        view.  If <TT
973
 
CLASS="LITERAL"
974
 
>ONLY</TT
975
 
> is specified, only that table is
976
 
        scanned.  If <TT
977
 
CLASS="LITERAL"
978
 
>ONLY</TT
979
 
> is not specified, the table and
980
 
        any descendant tables are scanned.
 
971
>        The name (optionally schema-qualified) of an existing table or view.
 
972
        If <TT
 
973
CLASS="LITERAL"
 
974
>ONLY</TT
 
975
> is specified before the table name, only that
 
976
        table is scanned.  If <TT
 
977
CLASS="LITERAL"
 
978
>ONLY</TT
 
979
> is not specified, the table
 
980
        and all its descendant tables (if any) are scanned.  Optionally,
 
981
        <TT
 
982
CLASS="LITERAL"
 
983
>*</TT
 
984
> can be specified after the table name to explicitly
 
985
        indicate that descendant tables are included.
981
986
       </P
982
987
></DD
983
988
><DT
3660
3665
><DIV
3661
3666
CLASS="REFSECT1"
3662
3667
><A
3663
 
NAME="AEN75114"
 
3668
NAME="AEN75151"
3664
3669
></A
3665
3670
><H2
3666
3671
>Examples</H2
3907
3912
><DIV
3908
3913
CLASS="REFSECT1"
3909
3914
><A
3910
 
NAME="AEN75148"
 
3915
NAME="AEN75185"
3911
3916
></A
3912
3917
><H2
3913
3918
>Compatibility</H2
3922
3927
><DIV
3923
3928
CLASS="REFSECT2"
3924
3929
><A
3925
 
NAME="AEN75152"
 
3930
NAME="AEN75189"
3926
3931
></A
3927
3932
><H3
3928
3933
>Omitted <TT
3982
3987
><DIV
3983
3988
CLASS="REFSECT2"
3984
3989
><A
3985
 
NAME="AEN75166"
 
3990
NAME="AEN75203"
3986
3991
></A
3987
3992
><H3
3988
3993
>Omitting the <TT
4031
4036
><DIV
4032
4037
CLASS="REFSECT2"
4033
4038
><A
4034
 
NAME="AEN75178"
 
4039
NAME="AEN75215"
4035
4040
></A
4036
4041
><H3
4037
4042
><TT
4038
4043
CLASS="LITERAL"
4039
4044
>ONLY</TT
4040
 
> and Parentheses</H3
 
4045
> and Inheritance</H3
4041
4046
><P
4042
 
>    The SQL standard requires parentheses around the table name
4043
 
    after <TT
 
4047
>    The SQL standard requires parentheses around the table name when
 
4048
    writing <TT
4044
4049
CLASS="LITERAL"
4045
4050
>ONLY</TT
4046
 
>, as in <TT
 
4051
>, for example <TT
4047
4052
CLASS="LITERAL"
4048
4053
>SELECT * FROM ONLY
4049
4054
    (tab1), ONLY (tab2) WHERE ...</TT
4050
 
>.  PostgreSQL supports that
4051
 
    as well, but the parentheses are optional.  (This point applies
4052
 
    equally to all SQL commands supporting the <TT
4053
 
CLASS="LITERAL"
4054
 
>ONLY</TT
 
4055
>.  <SPAN
 
4056
CLASS="PRODUCTNAME"
 
4057
>PostgreSQL</SPAN
4055
4058
>
4056
 
    option.)
 
4059
    considers these parentheses to be optional.
 
4060
   </P
 
4061
><P
 
4062
>    <SPAN
 
4063
CLASS="PRODUCTNAME"
 
4064
>PostgreSQL</SPAN
 
4065
> allows a trailing <TT
 
4066
CLASS="LITERAL"
 
4067
>*</TT
 
4068
> to be written to
 
4069
    explicitly specify the non-<TT
 
4070
CLASS="LITERAL"
 
4071
>ONLY</TT
 
4072
> behavior of including
 
4073
    child tables.  The standard does not allow this.
 
4074
   </P
 
4075
><P
 
4076
>    (These points apply equally to all SQL commands supporting the
 
4077
    <TT
 
4078
CLASS="LITERAL"
 
4079
>ONLY</TT
 
4080
> option.)
4057
4081
   </P
4058
4082
></DIV
4059
4083
><DIV
4060
4084
CLASS="REFSECT2"
4061
4085
><A
4062
 
NAME="AEN75185"
 
4086
NAME="AEN75228"
4063
4087
></A
4064
4088
><H3
4065
4089
>Namespace Available to <TT
4113
4137
><DIV
4114
4138
CLASS="REFSECT2"
4115
4139
><A
4116
 
NAME="AEN75198"
 
4140
NAME="AEN75241"
4117
4141
></A
4118
4142
><H3
4119
4143
>Functional Dependencies</H3
4137
4161
><DIV
4138
4162
CLASS="REFSECT2"
4139
4163
><A
4140
 
NAME="AEN75204"
 
4164
NAME="AEN75247"
4141
4165
></A
4142
4166
><H3
4143
4167
><TT
4162
4186
><DIV
4163
4187
CLASS="REFSECT2"
4164
4188
><A
4165
 
NAME="AEN75210"
 
4189
NAME="AEN75253"
4166
4190
></A
4167
4191
><H3
4168
4192
><TT
4220
4244
><DIV
4221
4245
CLASS="REFSECT2"
4222
4246
><A
4223
 
NAME="AEN75224"
 
4247
NAME="AEN75267"
4224
4248
></A
4225
4249
><H3
4226
4250
><TT
4263
4287
><DIV
4264
4288
CLASS="REFSECT2"
4265
4289
><A
4266
 
NAME="AEN75236"
 
4290
NAME="AEN75279"
4267
4291
></A
4268
4292
><H3
4269
4293
>Data-Modifying Statements in <TT
4294
4318
><DIV
4295
4319
CLASS="REFSECT2"
4296
4320
><A
4297
 
NAME="AEN75245"
 
4321
NAME="AEN75288"
4298
4322
></A
4299
4323
><H3
4300
4324
>Nonstandard Clauses</H3