← Back to branch summary

~aglenyoung/+junk/postgres-9.3-dtrace

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/queries-values.html

  • Committer: Package Import Robot
  • Author(s): Martin Pitt, Christoph Berg, Martin Pitt
  • Date: 2013-06-26 15:13:32 UTC
  • mfrom: (1.1.1)
  • Revision ID: package-import@ubuntu.com-20130626151332-p34yjpn0txbdsdzd
Tags: 9.3~beta2-1
[ Christoph Berg ]
* hurd-i386: Ignore testsuite failures so we have a working libpq5 (they
  don't implement semaphores so the server won't even start).
* Mark postgresql-9.3 as beta in the description, suggested by Joshua D.
  Drake.

[ Martin Pitt ]
* New upstream release 9.3 beta2.

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/queries-values.html
9
9
REV="MADE"
10
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
11
11
REL="HOME"
12
 
TITLE="PostgreSQL 9.3beta1 Documentation"
 
12
TITLE="PostgreSQL 9.3beta2 Documentation"
13
13
HREF="index.html"><LINK
14
14
REL="UP"
15
15
TITLE="Queries"
26
26
HTTP-EQUIV="Content-Type"
27
27
CONTENT="text/html; charset=ISO-8859-1"><META
28
28
NAME="creation"
29
 
CONTENT="2013-05-06T21:00:50"></HEAD
 
29
CONTENT="2013-06-24T19:00:38"></HEAD
30
30
><BODY
31
31
CLASS="SECT1"
32
32
><DIV
44
44
VALIGN="bottom"
45
45
><A
46
46
HREF="index.html"
47
 
>PostgreSQL 9.3beta1 Documentation</A
 
47
>PostgreSQL 9.3beta2 Documentation</A
48
48
></TH
49
49
></TR
50
50
><TR
165
165
> table.  The column names are not specified by the
166
166
   SQL standard and different database systems do it differently, so
167
167
   it's usually better to override the default names with a table alias
168
 
   list.
 
168
   list, like this:
 
169
</P><PRE
 
170
CLASS="PROGRAMLISTING"
 
171
>=&#62; SELECT * FROM (VALUES (1, 'one'), (2, 'two'), (3, 'three')) AS t (num,letter);
 
172
 num | letter
 
173
-----+--------
 
174
   1 | one
 
175
   2 | two
 
176
   3 | three
 
177
(3 rows)</PRE
 
178
><P>
169
179
  </P
170
180
><P
171
181
>   Syntactically, <TT