← 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/tablefunc.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-06-14 09:53:29 UTC
  • mto: (6.1.1 sid) (10.1.1 oneiric-proposed) (1.2.1)
  • mto: This revision was merged to the branch mainline in revision 5.
  • Revision ID: james.westby@ubuntu.com-20110614095329-71gfhjywyp2c27au
Tags: upstream-9.1~beta2
Import upstream version 9.1~beta2

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/tablefunc.html
9
9
REV="MADE"
10
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
11
11
REL="HOME"
12
 
TITLE="PostgreSQL 9.1beta1 Documentation"
 
12
TITLE="PostgreSQL 9.1beta2 Documentation"
13
13
HREF="index.html"><LINK
14
14
REL="UP"
15
15
TITLE="Additional Supplied Modules"
26
26
HTTP-EQUIV="Content-Type"
27
27
CONTENT="text/html; charset=ISO-8859-1"><META
28
28
NAME="creation"
29
 
CONTENT="2011-04-27T21:20:33"></HEAD
 
29
CONTENT="2011-06-09T23:44:43"></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.1beta1 Documentation</A
 
47
>PostgreSQL 9.1beta2 Documentation</A
48
48
></TH
49
49
></TR
50
50
><TR
118
118
><H2
119
119
CLASS="SECT2"
120
120
><A
121
 
NAME="AEN135135"
 
121
NAME="AEN135267"
122
122
>F.41.1. Functions Provided</A
123
123
></H2
124
124
><P
331
331
><H3
332
332
CLASS="SECT3"
333
333
><A
334
 
NAME="AEN135202"
 
334
NAME="AEN135334"
335
335
>F.41.1.1. <CODE
336
336
CLASS="FUNCTION"
337
337
>normal_rand</CODE
389
389
><H3
390
390
CLASS="SECT3"
391
391
><A
392
 
NAME="AEN135214"
 
392
NAME="AEN135346"
393
393
>F.41.1.2. <CODE
394
394
CLASS="FUNCTION"
395
395
>crosstab(text)</CODE
614
614
><H3
615
615
CLASS="SECT3"
616
616
><A
617
 
NAME="AEN135258"
 
617
NAME="AEN135390"
618
618
>F.41.1.3. <CODE
619
619
CLASS="FUNCTION"
620
620
>crosstab<TT
799
799
><H3
800
800
CLASS="SECT3"
801
801
><A
802
 
NAME="AEN135297"
 
802
NAME="AEN135429"
803
803
>F.41.1.4. <CODE
804
804
CLASS="FUNCTION"
805
805
>crosstab(text, text)</CODE
886
886
    something like:
887
887
</P><PRE
888
888
CLASS="PROGRAMLISTING"
889
 
> SELECT row_name, extra_col, cat, value FROM foo ORDER BY 1;
 
889
>SELECT row_name, extra_col, cat, value FROM foo ORDER BY 1;
890
890
 
891
 
     row_name    extra_col   cat    value
892
 
    ----------+------------+-----+---------
893
 
      row1         extra1    cat1    val1
894
 
      row1         extra1    cat2    val2
895
 
      row1         extra1    cat4    val4
896
 
      row2         extra2    cat1    val5
897
 
      row2         extra2    cat2    val6
898
 
      row2         extra2    cat3    val7
899
 
      row2         extra2    cat4    val8</PRE
 
891
 row_name    extra_col   cat    value
 
892
----------+------------+-----+---------
 
893
  row1         extra1    cat1    val1
 
894
  row1         extra1    cat2    val2
 
895
  row1         extra1    cat4    val4
 
896
  row2         extra2    cat1    val5
 
897
  row2         extra2    cat2    val6
 
898
  row2         extra2    cat3    val7
 
899
  row2         extra2    cat4    val8</PRE
900
900
><P>
901
901
   </P
902
902
><P
1147
1147
><H3
1148
1148
CLASS="SECT3"
1149
1149
><A
1150
 
NAME="AEN135363"
 
1150
NAME="AEN135495"
1151
1151
>F.41.1.5. <CODE
1152
1152
CLASS="FUNCTION"
1153
1153
>connectby</CODE
1462
1462
><H2
1463
1463
CLASS="SECT2"
1464
1464
><A
1465
 
NAME="AEN135440"
 
1465
NAME="AEN135572"
1466
1466
>F.41.2. Author</A
1467
1467
></H2
1468
1468
><P