← Back to branch summary

~ubuntu-branches/ubuntu/hardy/postgresql-8.4/hardy-backports

« back to all changes in this revision

Viewing changes to src/test/regress/expected/with.out

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2009-04-27 08:35:30 UTC
  • mfrom: (1.1.1 upstream)
  • Revision ID: james.westby@ubuntu.com-20090427083530-jhwzvyit4pbf64h1
Tags: 8.4~beta1-1
* First public beta of 8.4.
* debian/*.install: Add new gettext translations.
* debian/control: Bump p-common dependency to >= 98 to ensure support for
  8.4.
* debian/rules: Build with --enable-cassert while in beta.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/test/regress/expected/with.out
451
451
  3 |     7
452
452
(2 rows)
453
453
 
 
454
-- this variant tickled a whole-row-variable bug in 8.4devel
 
455
WITH RECURSIVE t(id, path) AS (
 
456
    VALUES(1,ARRAY[]::integer[])
 
457
UNION ALL
 
458
    SELECT tree.id, t.path || tree.id
 
459
    FROM tree JOIN t ON (tree.parent_id = t.id)
 
460
)
 
461
SELECT t1.id, t2.path, t2 FROM t AS t1 JOIN t AS t2 ON
 
462
(t1.id=t2.id);
 
463
 id |    path     |         t2         
 
464
----+-------------+--------------------
 
465
  1 | {}          | (1,{})
 
466
  2 | {2}         | (2,{2})
 
467
  3 | {3}         | (3,{3})
 
468
  4 | {2,4}       | (4,"{2,4}")
 
469
  5 | {2,5}       | (5,"{2,5}")
 
470
  6 | {2,6}       | (6,"{2,6}")
 
471
  7 | {3,7}       | (7,"{3,7}")
 
472
  8 | {3,8}       | (8,"{3,8}")
 
473
  9 | {2,4,9}     | (9,"{2,4,9}")
 
474
 10 | {2,4,10}    | (10,"{2,4,10}")
 
475
 11 | {3,7,11}    | (11,"{3,7,11}")
 
476
 12 | {3,7,12}    | (12,"{3,7,12}")
 
477
 13 | {3,7,13}    | (13,"{3,7,13}")
 
478
 14 | {2,4,9,14}  | (14,"{2,4,9,14}")
 
479
 15 | {3,7,11,15} | (15,"{3,7,11,15}")
 
480
 16 | {3,7,11,16} | (16,"{3,7,11,16}")
 
481
(16 rows)
 
482
 
454
483
--
455
484
-- test cycle detection
456
485
--