> From: Thomas Lockhart <lockhart@alumni.caltech.edu>
> > > You will need to inspect your results to see what is failing. Which
> > > release are you running?
> > I run PG 6.5.2 on LinuxPPC 1999.
> > which files should I look at?
>
> cd src/test/regress
> diff expected/<test>.out results/<test>.out
I hope, the following does help.
---
_ _
_(_)(_)_ David Wetzel, Turbocat's Development,
(_) __ (_) Buchhorster Strasse, D-16567 Muehlenbeck/Berlin, FRG,
_/ \_ Fax +49 33056 82835 NeXTmail dave@turbocat.de
(______) http://www.turbocat.de/
DEVELOPMENT * CONSULTING * ADMINISTRATION
[dave@morpheus regress]# diff expected/geometry.out results/geometry.out
115c115
< |(-10,0)
|[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140473)
---
> |(-10,0)
|[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
132,134c132,134
< |(71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548)
< |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738)
< |(3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559643)
---
> |(71.7106781186547,72.7106781186547),(-69.7106781186547,-68.7106781186547)
> |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737)
> |(3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642)
136c136
< |(170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548)
---
> |(170.710678118655,70.7106781186547),(29.2893218813453,-70.7106781186547)
411,418c411,418
< six|polygon
<
---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<
|((-3,0),(-2.59807621135332,1.5),(-1.5,2.59807621135332),(-1.83690953073357e-16,3),(1.5,2.59807621135332),(2.59807621135332,1.5),(3,3.67381906146713e-16),(2.59807621135332,-1.5),(1.5,-2.59807621135332),(5.5107285922007e-16,-3),(-1.5,-2.59807621135332),(-2.59807621135332,-1.5))
<
|((-99,2),(-85.6025403784439,52),(-49,88.6025403784439),(0.999999999999994,102),(51,88.6025403784439),(87.6025403784439,52),(101,2.00000000000001),(87.6025403784439,-48),(51,-84.6025403784438),(1.00000000000002,-98),(-49,-84.6025403784439),(-85.6025403784438,-48))
<
|((-4,3),(-3.33012701892219,5.5),(-1.5,7.33012701892219),(1,8),(3.5,7.33012701892219),(5.33012701892219,5.5),(6,3),(5.33012701892219,0.500000000000001),(3.5,-1.33012701892219),(1,-2),(-1.5,-1.33012701892219),(-3.33012701892219,0.499999999999998))
<
|((-2,2),(-1.59807621135332,3.5),(-0.5,4.59807621135332),(1,5),(2.5,4.59807621135332),(3.59807621135332,3.5),(4,2),(3.59807621135332,0.500000000000001),(2.5,-0.598076211353315),(1,-1),(-0.5,-0.598076211353316),(-1.59807621135332,0.499999999999999))
<
|((90,200),(91.3397459621556,205),(95,208.660254037844),(100,210),(105,208.660254037844),(108.660254037844,205),(110,200),(108.660254037844,195),(105,191.339745962156),(100,190),(95,191.339745962156),(91.3397459621556,195))
<
|((0,0),(13.3974596215561,50),(50,86.6025403784439),(100,100),(150,86.6025403784439),(186.602540378444,50),(200,1.22460635382238e-14),(186.602540378444,-50),(150,-86.6025403784438),(100,-100),(50,-86.6025403784439),(13.3974596215562,-50))
---
> six|polygon
>
---+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
|((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
>
|((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))
>
|((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028))
>
|((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616))
>
|((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
>
|((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
423,430c423,430
< six|polygon
<
---+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<
|((-3,0),(-2.12132034355964,2.12132034355964),(-1.83690953073357e-16,3),(2.12132034355964,2.12132034355964),(3,3.67381906146713e-16),(2.12132034355964,-2.12132034355964),(5.5107285922007e-16,-3),(-2.12132034355964,-2.12132034355964))
<
|((-99,2),(-69.7106781186548,72.7106781186548),(0.999999999999994,102),(71.7106781186547,72.7106781186548),(101,2.00000000000001),(71.7106781186548,-68.7106781186547),(1.00000000000002,-98),(-69.7106781186547,-68.7106781186548))
<
|((-4,3),(-2.53553390593274,6.53553390593274),(1,8),(4.53553390593274,6.53553390593274),(6,3),(4.53553390593274,-0.535533905932737),(1,-2),(-2.53553390593274,-0.535533905932738))
<
|((-2,2),(-1.12132034355964,4.12132034355964),(1,5),(3.12132034355964,4.12132034355964),(4,2),(3.12132034355964,-0.121320343559642),(1,-1),(-1.12132034355964,-0.121320343559643))
<
|((90,200),(92.9289321881345,207.071067811865),(100,210),(107.071067811865,207.071067811865),(110,200),(107.071067811865,192.928932188135),(100,190),(92.9289321881345,192.928932188135))
<
|((0,0),(29.2893218813452,70.7106781186548),(100,100),(170.710678118655,70.7106781186548),(200,1.22460635382238e-14),(170.710678118655,-70.7106781186547),(100,-100),(29.2893218813453,-70.7106781186548))
---
> six|polygon
>
---+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
|((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175))
>
|((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
>
|((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
>
|((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
>
|((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
>
|((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
468,493c468,493
< twentyfour|circle |point | distance
< ----------+--------------+----------+-----------------
< |<(100,0),100> |(5.1,34.5)|0.976531926977964
< |<(1,2),3> |(-3,4) | 1.47213595499958
< |<(0,0),3> |(-3,4) | 2
< |<(100,0),100> |(-3,4) | 3.07764064044151
< |<(100,0),100> |(-5,-12) | 5.68348972285122
< |<(1,3),5> |(-10,0) | 6.40175425099138
< |<(1,3),5> |(10,10) | 6.40175425099138
< |<(0,0),3> |(-10,0) | 7
< |<(1,2),3> |(-10,0) | 8.18033988749895
< |<(1,2),3> |(10,10) | 9.0415945787923
< |<(0,0),3> |(-5,-12) | 10
< |<(100,0),100> |(-10,0) | 10
< |<(0,0),3> |(10,10) | 11.142135623731
< |<(1,3),5> |(-5,-12) | 11.1554944214035
< |<(1,2),3> |(-5,-12) | 12.2315462117278
< |<(1,3),5> |(5.1,34.5)| 26.7657047773224
< |<(1,2),3> |(5.1,34.5)| 29.757594539282
< |<(0,0),3> |(5.1,34.5)| 31.8749193547455
< |<(100,200),10>|(5.1,34.5)| 180.778038568384
< |<(100,200),10>|(10,10) | 200.237960416286
< |<(100,200),10>|(-3,4) | 211.415898254845
< |<(100,200),10>|(0,0) | 213.606797749979
< |<(100,200),10>|(-10,0) | 218.254244210267
< |<(100,200),10>|(-5,-12) | 226.577682802077
---
> twentyfour|circle |point | distance
> ----------+--------------+----------+----------------
> |<(100,0),100> |(5.1,34.5)|0.97653192697797
> |<(1,2),3> |(-3,4) |1.47213595499958
> |<(0,0),3> |(-3,4) | 2
> |<(100,0),100> |(-3,4) |3.07764064044152
> |<(100,0),100> |(-5,-12) |5.68348972285122
> |<(1,3),5> |(-10,0) |6.40175425099138
> |<(1,3),5> |(10,10) |6.40175425099138
> |<(0,0),3> |(-10,0) | 7
> |<(1,2),3> |(-10,0) |8.18033988749895
> |<(1,2),3> |(10,10) | 9.0415945787923
> |<(0,0),3> |(-5,-12) | 10
> |<(100,0),100> |(-10,0) | 10
> |<(0,0),3> |(10,10) | 11.142135623731
> |<(1,3),5> |(-5,-12) |11.1554944214035
> |<(1,2),3> |(-5,-12) |12.2315462117278
> |<(1,3),5> |(5.1,34.5)|26.7657047773223
> |<(1,2),3> |(5.1,34.5)| 29.757594539282
> |<(0,0),3> |(5.1,34.5)|31.8749193547455
> |<(100,200),10>|(5.1,34.5)|180.778038568384
> |<(100,200),10>|(10,10) |200.237960416286
> |<(100,200),10>|(-3,4) |211.415898254845
> |<(100,200),10>|(0,0) |213.606797749979
> |<(100,200),10>|(-10,0) |218.254244210267
> |<(100,200),10>|(-5,-12) |226.577682802077
[dave@morpheus regress]# cat results/sanity_check.out
QUERY: VACUUM;
ERROR: nodeRead: Bad type 0
QUERY: SELECT relname, relhasindex
FROM pg_class
WHERE relhasindex
ORDER BY relname;
relname |relhasindex
--------------+-----------
bt_f8_heap |t
bt_i4_heap |t
bt_name_heap |t
bt_txt_heap |t
fast_emp4000 |t
hash_f8_heap |t
hash_i4_heap |t
hash_name_heap|t
hash_txt_heap |t
ihighway |t
onek |t
pg_attrdef |t
pg_attribute |t
pg_class |t
pg_description|t
pg_proc |t
pg_relcheck |t
pg_trigger |t
pg_type |t
road |t
shighway |t
tenk1 |t
tenk2 |t
(23 rows)
[dave@morpheus regress]# cat expected/sanity_check.out
QUERY: VACUUM;
QUERY: SELECT relname, relhasindex
FROM pg_class
WHERE relhasindex
ORDER BY relname;
relname |relhasindex
--------------+-----------
bt_f8_heap |t
bt_i4_heap |t
bt_name_heap |t
bt_txt_heap |t
fast_emp4000 |t
hash_f8_heap |t
hash_i4_heap |t
hash_name_heap|t
hash_txt_heap |t
ihighway |t
onek |t
pg_attrdef |t
pg_attribute |t
pg_class |t
pg_description|t
pg_proc |t
pg_relcheck |t
pg_trigger |t
pg_type |t
road |t
shighway |t
tenk1 |t
tenk2 |t
(23 rows)
[dave@morpheus regress]# diff expected/select_views.out results/select_views.out
4a5
> Ada St |[(-122.2487,37.398),(-122.2496,37.401)]
|Lafayette
5a7,8
> Allen Ct |[(-122.0131,37.602),(-122.0117,37.597)]
|Berkeley
> Alvarado Niles Road|[(-122.0325,37.903),(-122.0316,37.9)]
|Berkeley
7a11,12
> Arden Road|[(-122.0978,37.177),(-122.1,37.177)]
|Oakland
> Arizona St |[(-122.0381,37.901),(-122.0367,37.898)]
|Berkeley
12,55d16
< Calaveras Creek |[(-121.8203,37.035),(-121.8207,37.931)]
|Oakland
< Corriea Way |[(-121.9501,37.402),(-121.9505,37.398)]
|Oakland
< Cowing Road|[(-122.0002,37.934),(-121.9772,37.782)]
|Oakland
< Driscoll
Road|[(-121.9482,37.403),(-121.948451,37.39995)]
|Oakland
< Enos Way |[(-121.7677,37.896),(-121.7673,37.91)]
|Oakland
< Fairview Ave |[(-121.999,37.428),(-121.9863,37.351)]
|Oakland
< I- 580
|[(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]
|Oakland
< I- 580
|[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]
|Oakland
< I- 580
Ramp|[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]
|Oakland
< I- 580
Ramp|[(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]
|Oakland
< I- 580
Ramp|[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]
|Oakland
< I- 580
Ramp|[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]
|Oakland
< I- 580/I-680 Ramp|((-121.9207,37.988),(-121.9192,37.016))
|Oakland
< I- 680
|((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
|Oakland
< I- 680
|[(-121.9101,37.715),(-121.911269,37.74682),(-121.9119,37.764),(-121.9124,37.776),(-121.9174,37.905),(-121.9194,37.957),(-121.9207,37.988)]
|Oakland
< I- 680
|[(-121.9184,37.934),(-121.917,37.913),(-121.9122,37.83),(-121.9052,37.702)]
|Oakland
< I- 680
Ramp|[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]
|Oakland
< I- 680
Ramp|[(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]
|Oakland
< I- 680
Ramp|[(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]
|Oakland
< I- 880
|((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))
|Oakland
< I- 880
|[(-121.948,37.933),(-121.9471,37.925),(-121.9467,37.923),(-121.946,37.918),(-121.9452,37.912),(-121.937,37.852)]
|Oakland
< Johnson Dr |[(-121.9145,37.901),(-121.915,37.877)]
|Oakland
< Juniper St |[(-121.7823,37.897),(-121.7815,37.9)]
|Oakland
< Las Positas
Road|[(-121.764488,37.99199),(-121.75569,37.02022)]
|Oakland
< Livermore Ave |[(-121.7687,37.448),(-121.769,37.375)]
|Oakland
< Livermore Ave
|[(-121.772719,37.99085),(-121.7728,37.001)]
|Oakland
< Mission
Blvd|[(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]
|Oakland
< Navajo Ct |[(-121.8779,37.901),(-121.8783,37.9)]
|Oakland
< Pimlico Dr |[(-121.8616,37.998),(-121.8618,37.008)]
|Oakland
< Rosedale Ct |[(-121.9232,37.9),(-121.924,37.897)]
|Oakland
< Saginaw Ct |[(-121.8803,37.898),(-121.8806,37.901)]
|Oakland
< Sp Railroad
|[(-121.893564,37.99009),(-121.897,37.016)]
|Oakland
< Sp Railroad |[(-121.9565,37.898),(-121.9562,37.9)]
|Oakland
< State Hwy 84
|[(-121.9565,37.898),(-121.956589,37.89911),(-121.9569,37.903),(-121.956,37.91),(-121.9553,37.919)]
|Oakland
< Sunol Ridge Trl |[(-121.9419,37.455),(-121.9345,37.38)]
|Oakland
< Tassajara Creek
|[(-121.87866,37.98898),(-121.8782,37.015)]
|Oakland
< Theresa Way |[(-121.7289,37.906),(-121.728,37.899)]
|Oakland
< Tissiack Way |[(-121.920364,37),(-121.9208,37.995)]
|Oakland
< Vallecitos Road|[(-121.8699,37.916),(-121.8703,37.891)]
|Oakland
< Warm Springs Blvd|[(-121.933956,37),(-121.9343,37.97)]
|Oakland
< Welch Creek Road|[(-121.7695,37.386),(-121.7737,37.413)]
|Oakland
< Whitlock Creek
|[(-121.74683,37.91276),(-121.733107,37)]
|Oakland
< 1st St
|[(-121.75508,37.89294),(-121.753581,37.90031)]
|Oakland
< Arden Road|[(-122.0978,37.177),(-122.1,37.177)]
|Oakland
57,94d17
< Bridgepointe Dr |[(-122.0514,37.305),(-122.0509,37.299)]
|Oakland
< Butterfield Dr |[(-122.0838,37.002),(-122.0834,37.987)]
|Oakland
< Celia St |[(-122.0611,37.3),(-122.0616,37.299)]
|Oakland
< Claremont Pl |[(-122.0542,37.995),(-122.0542,37.008)]
|Oakland
< Crystaline Dr
|[(-121.925856,37),(-121.925869,37.00527)]
|Oakland
< Decoto
Road|[(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
|Oakland
< Eden Creek
|[(-122.022037,37.00675),(-122.0221,37.998)]
|Oakland
< Hesperian
Blvd|[(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]
|Oakland
< I- 580
|[(-121.727,37.074),(-121.7229,37.093),(-121.722301,37.09522),(-121.721001,37.10005),(-121.7194,37.106),(-121.7188,37.109),(-121.7168,37.12),(-121.7163,37.123),(-121.7145,37.127),(-121.7096,37.148),(-121.707731,37.1568),(-121.7058,37.166),(-121.7055,37.168),(-121.7044,37.174),(-121.7038,37.172),(-121.7037,37.172),(-121.7027,37.175),(-121.7001,37.181),(-121.6957,37.191),(-121.6948,37.192),(-121.6897,37.204),(-121.6697,37.185)]|Oakland
< I- 680
|((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
|Oakland
< I- 880
|((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))
|Oakland
< I- 880
|[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
|Oakland
< I- 880
|[(-122.0831,37.312),(-122.0819,37.296),(-122.081,37.285),(-122.0786,37.248),(-122.078,37.24),(-122.077642,37.23496),(-122.076983,37.22567),(-122.076599,37.22026),(-122.076229,37.21505),(-122.0758,37.209)]
|Oakland
< I- 880 Ramp|[(-122.0019,37.301),(-122.002,37.293)]
|Oakland
< I- 880
Ramp|[(-122.0041,37.313),(-122.0018,37.315),(-122.0007,37.315),(-122.0005,37.313),(-122.0002,37.308),(-121.9995,37.289)]
|Oakland
< I- 880
Ramp|[(-122.0041,37.313),(-122.0038,37.308),(-122.0039,37.284),(-122.0013,37.287),(-121.9995,37.289)]
|Oakland
< I- 880
Ramp|[(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
|Oakland
< I- 880
Ramp|[(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
|Oakland
< I- 880
Ramp|[(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]
|Oakland
< I- 880
Ramp|[(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]
|Oakland
< Kildare Road|[(-122.0968,37.016),(-122.0959,37)]
|Oakland
< Mildred Ct |[(-122.0002,37.388),(-121.9998,37.386)]
|Oakland
< Miramar Ave
|[(-122.1009,37.025),(-122.099089,37.03209)]
|Oakland
< Mission
Blvd|[(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]
|Oakland
< Moores Ave |[(-122.0087,37.301),(-122.0094,37.292)]
|Oakland
< Oakridge Road|[(-121.8316,37.049),(-121.828382,37)]
|Oakland
< Paseo Padre Pkwy|[(-121.9143,37.005),(-121.913522,37)]
|Oakland
< Periwinkle
Road|[(-122.0451,37.301),(-122.044758,37.29844)]
|Oakland
< Railroad Ave
|[(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
|Oakland
< Ranspot Dr |[(-122.0972,37.999),(-122.0959,37)]
|Oakland
< Santa Maria Ave |[(-122.0773,37),(-122.0773,37.98)]
|Oakland
< Sp Railroad |[(-122.0734,37.001),(-122.0734,37.997)]
|Oakland
< Stanton Ave
|[(-122.100392,37.0697),(-122.099513,37.06052)]
|Oakland
< Thackeray Ave |[(-122.072,37.305),(-122.0715,37.298)]
|Oakland
< Tissiack Way |[(-121.920364,37),(-121.9208,37.995)]
|Oakland
< Warm Springs Blvd|[(-121.933956,37),(-121.9343,37.97)]
|Oakland
< Western Pacific Railroad Spur |[(-122.0394,37.018),(-122.0394,37.961)]
|Oakland
< Whitlock Creek
|[(-121.74683,37.91276),(-121.733107,37)]
|Oakland
95a19
> Avenue 134th |[(-122.1823,37.002),(-122.1851,37.992)]
|Berkeley
96a21
> Avenue 140th |[(-122.1656,37.003),(-122.1691,37.988)]
|Berkeley
101a27
> Bridgepointe Dr |[(-122.0514,37.305),(-122.0509,37.299)]
|Oakland
103,160d28
< Butterfield Dr |[(-122.0838,37.002),(-122.0834,37.987)]
|Oakland
< C St |[(-122.1768,37.46),(-122.1749,37.435)]
|Oakland
< Cameron Ave |[(-122.1316,37.502),(-122.1327,37.481)]
|Oakland
< Chapman Dr |[(-122.0421,37.504),(-122.0414,37.498)]
|Oakland
< Charles St |[(-122.0255,37.505),(-122.0252,37.499)]
|Oakland
< Claremont Pl |[(-122.0542,37.995),(-122.0542,37.008)]
|Oakland
< Coliseum Way |[(-122.2001,37.47),(-122.1978,37.516)]
|Oakland
< D St |[(-122.1811,37.505),(-122.1805,37.497)]
|Oakland
< Decoto
Road|[(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
|Oakland
< E St
|[(-122.1832,37.505),(-122.1826,37.498),(-122.182,37.49)]
|Oakland
< Eden Ave |[(-122.1143,37.505),(-122.1142,37.491)]
|Oakland
< Eden Creek
|[(-122.022037,37.00675),(-122.0221,37.998)]
|Oakland
< Hegenberger Exwy|[(-122.1946,37.52),(-122.1947,37.497)]
|Oakland
< Herrier St |[(-122.1943,37.006),(-122.1936,37.998)]
|Oakland
< I- 580
|[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]
|Oakland
< I- 580
|[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
|Oakland
< I- 580
Ramp|[(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]
|Oakland
< I- 580
Ramp|[(-122.1414,37.383),(-122.1407,37.376),(-122.1403,37.372),(-122.139,37.356)]
|Oakland
< I- 880
|[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]
|Oakland
< I- 880
|[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
|Oakland
< I- 880
|[(-122.0978,37.528),(-122.096,37.496),(-122.0931,37.453),(-122.09277,37.4496),(-122.090189,37.41442),(-122.0896,37.405),(-122.085,37.34)]
|Oakland
< I- 880
|[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
|Oakland
< I- 880
Ramp|[(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
|Oakland
< I- 880
Ramp|[(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
|Oakland
< Kaiser Dr
|[(-122.067163,37.47821),(-122.060402,37.51961)]
|Oakland
< La Playa Dr |[(-122.1039,37.545),(-122.101,37.493)]
|Oakland
< Locust St |[(-122.1606,37.007),(-122.1593,37.987)]
|Oakland
< Magnolia St |[(-122.0971,37.5),(-122.0962,37.484)]
|Oakland
< Mattos Dr
|[(-122.0005,37.502),(-122.000898,37.49683)]
|Oakland
< Maubert Ave |[(-122.1114,37.009),(-122.1096,37.995)]
|Oakland
< McClure Ave |[(-122.1431,37.001),(-122.1436,37.998)]
|Oakland
< National Ave |[(-122.1192,37.5),(-122.1281,37.489)]
|Oakland
< Portsmouth Ave |[(-122.1064,37.315),(-122.1064,37.308)]
|Oakland
< Railroad Ave
|[(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
|Oakland
< Ranspot Dr |[(-122.0972,37.999),(-122.0959,37)]
|Oakland
< Redwood Road|[(-122.1493,37.98),(-122.1437,37.001)]
|Oakland
< Santa Maria Ave |[(-122.0773,37),(-122.0773,37.98)]
|Oakland
< Skyline Blvd|[(-122.1738,37.01),(-122.1714,37.996)]
|Oakland
< Skyline Dr |[(-122.0277,37.5),(-122.0284,37.498)]
|Oakland
< Sp Railroad |[(-122.0734,37.001),(-122.0734,37.997)]
|Oakland
< Sp Railroad
|[(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]
|Oakland
< Sp Railroad
|[(-122.1947,37.497),(-122.193328,37.4848)]
|Oakland
< State Hwy 92
|[(-122.1085,37.326),(-122.1095,37.322),(-122.1111,37.316),(-122.1119,37.313),(-122.1125,37.311),(-122.1131,37.308),(-122.1167,37.292),(-122.1187,37.285),(-122.12,37.28)]
|Oakland
< State Hwy 92
Ramp|[(-122.1086,37.321),(-122.1089,37.315),(-122.1111,37.316)]
|Oakland
< Western Pacific Railroad Spur |[(-122.0394,37.018),(-122.0394,37.961)]
|Oakland
< Willimet Way |[(-122.0964,37.517),(-122.0949,37.493)]
|Oakland
< Wisconsin St
|[(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]
|Oakland
< 100th Ave |[(-122.1657,37.429),(-122.1647,37.432)]
|Oakland
< 107th Ave |[(-122.1555,37.403),(-122.1531,37.41)]
|Oakland
< 85th Ave |[(-122.1877,37.466),(-122.186,37.476)]
|Oakland
< 89th Ave |[(-122.1822,37.459),(-122.1803,37.471)]
|Oakland
< 98th Ave |[(-122.1568,37.498),(-122.1558,37.502)]
|Oakland
< 98th Ave |[(-122.1693,37.438),(-122.1682,37.444)]
|Oakland
< Allen Ct |[(-122.0131,37.602),(-122.0117,37.597)]
|Berkeley
< Alvarado Niles Road|[(-122.0325,37.903),(-122.0316,37.9)]
|Berkeley
< Arizona St |[(-122.0381,37.901),(-122.0367,37.898)]
|Berkeley
< Avenue 134th |[(-122.1823,37.002),(-122.1851,37.992)]
|Berkeley
< Avenue 140th |[(-122.1656,37.003),(-122.1691,37.988)]
|Berkeley
162a31,32
> Butterfield Dr |[(-122.0838,37.002),(-122.0834,37.987)]
|Oakland
> Butterfield Dr |[(-122.0838,37.002),(-122.0834,37.987)]
|Oakland
163a34,35
> C St |[(-122.1768,37.46),(-122.1749,37.435)]
|Oakland
> Calaveras Creek |[(-121.8203,37.035),(-121.8207,37.931)]
|Oakland
164a37,38
> California St |[(-122.2032,37.005),(-122.2016,37.996)]
|Lafayette
> Cameron Ave |[(-122.1316,37.502),(-122.1327,37.481)]
|Oakland
165a40
> Capricorn Ave |[(-122.2176,37.404),(-122.2164,37.384)]
|Lafayette
166a42
> Celia St |[(-122.0611,37.3),(-122.0616,37.299)]
|Oakland
167a44,45
> Chambers Dr |[(-122.2004,37.352),(-122.1972,37.368)]
|Lafayette
> Chambers Lane|[(-122.2001,37.359),(-122.1975,37.371)]
|Lafayette
168a47,51
> Champion St |[(-122.214,37.991),(-122.2147,37.002)]
|Lafayette
> Chapman Dr |[(-122.0421,37.504),(-122.0414,37.498)]
|Oakland
> Charles St |[(-122.0255,37.505),(-122.0252,37.499)]
|Oakland
> Claremont Pl |[(-122.0542,37.995),(-122.0542,37.008)]
|Oakland
> Claremont Pl |[(-122.0542,37.995),(-122.0542,37.008)]
|Oakland
169a53
> Coliseum Way |[(-122.2001,37.47),(-122.1978,37.516)]
|Oakland
170a55
> Coolidge Ave |[(-122.2007,37.058),(-122.1992,37.06)]
|Lafayette
171a57,58
> Corriea Way |[(-121.9501,37.402),(-121.9505,37.398)]
|Oakland
> Cowing Road|[(-122.0002,37.934),(-121.9772,37.782)]
|Oakland
172a60
> Creston
Road|[(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]
|Lafayette
173a62
> Crystaline Dr
|[(-121.925856,37),(-121.925869,37.00527)]
|Oakland
174a64,66
> D St |[(-122.1811,37.505),(-122.1805,37.497)]
|Oakland
> Decoto
Road|[(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
|Oakland
> Decoto
Road|[(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
|Oakland
177a70
> Dimond Ave |[(-122.2167,37.994),(-122.2162,37.006)]
|Lafayette
178a72,76
> Driscoll
Road|[(-121.9482,37.403),(-121.948451,37.39995)]
|Oakland
> E St
|[(-122.1832,37.505),(-122.1826,37.498),(-122.182,37.49)]
|Oakland
> Eden Ave |[(-122.1143,37.505),(-122.1142,37.491)]
|Oakland
> Eden Creek
|[(-122.022037,37.00675),(-122.0221,37.998)]
|Oakland
> Eden Creek
|[(-122.022037,37.00675),(-122.0221,37.998)]
|Oakland
179a78,79
> Edgewater Dr |[(-122.201,37.379),(-122.2042,37.41)]
|Lafayette
> Enos Way |[(-121.7677,37.896),(-121.7673,37.91)]
|Oakland
180a81,82
> Euclid Ave |[(-122.2671,37.009),(-122.2666,37.987)]
|Lafayette
> Fairview Ave |[(-121.999,37.428),(-121.9863,37.351)]
|Oakland
184a87,89
> Heartwood Dr |[(-122.2006,37.341),(-122.1992,37.338)]
|Lafayette
> Hegenberger Exwy|[(-122.1946,37.52),(-122.1947,37.497)]
|Oakland
> Herrier St |[(-122.1943,37.006),(-122.1936,37.998)]
|Oakland
185a91
> Hesperian
Blvd|[(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]
|Oakland
186a93,97
> Hollis St |[(-122.2885,37.397),(-122.289,37.414)]
|Lafayette
> I- 580
|[(-121.727,37.074),(-121.7229,37.093),(-121.722301,37.09522),(-121.721001,37.10005),(-121.7194,37.106),(-121.7188,37.109),(-121.7168,37.12),(-121.7163,37.123),(-121.7145,37.127),(-121.7096,37.148),(-121.707731,37.1568),(-121.7058,37.166),(-121.7055,37.168),(-121.7044,37.174),(-121.7038,37.172),(-121.7037,37.172),(-121.7027,37.175),(-121.7001,37.181),(-121.6957,37.191),(-121.6948,37.192),(-121.6897,37.204),(-121.6697,37.185)]|Oakland
> I- 580
|[(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]
|Oakland
> I- 580
|[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]
|Oakland
> I- 580
|[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]
|Oakland
187a99
> I- 580
|[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
|Oakland
189a102,106
> I- 580
|[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]
|Lafayette
> I- 580
Ramp|[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]
|Oakland
> I- 580
Ramp|[(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]
|Oakland
> I- 580
Ramp|[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]
|Oakland
> I- 580
Ramp|[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]
|Oakland
194a112
> I- 580
Ramp|[(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]
|Oakland
195a114,127
> I- 580
Ramp|[(-122.1414,37.383),(-122.1407,37.376),(-122.1403,37.372),(-122.139,37.356)]
|Oakland
> I- 580/I-680 Ramp|((-121.9207,37.988),(-121.9192,37.016))
|Oakland
> I- 680
|((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
|Oakland
> I- 680
|((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
|Oakland
> I- 680
|[(-121.9101,37.715),(-121.911269,37.74682),(-121.9119,37.764),(-121.9124,37.776),(-121.9174,37.905),(-121.9194,37.957),(-121.9207,37.988)]
|Oakland
> I- 680
|[(-121.9184,37.934),(-121.917,37.913),(-121.9122,37.83),(-121.9052,37.702)]
|Oakland
> I- 680
Ramp|[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]
|Oakland
> I- 680
Ramp|[(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]
|Oakland
> I- 680
Ramp|[(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]
|Oakland
> I- 80
Ramp|[(-122.2962,37.413),(-122.2959,37.382),(-122.2951,37.372)]
|Lafayette
> I- 880
|((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))
|Oakland
> I- 880
|((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))
|Oakland
> I- 880
|[(-121.948,37.933),(-121.9471,37.925),(-121.9467,37.923),(-121.946,37.918),(-121.9452,37.912),(-121.937,37.852)]
|Oakland
> I- 880
|[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]
|Oakland
196a129,130
> I- 880
|[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
|Oakland
> I- 880
|[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
|Oakland
197a132,133
> I- 880
|[(-122.0831,37.312),(-122.0819,37.296),(-122.081,37.285),(-122.0786,37.248),(-122.078,37.24),(-122.077642,37.23496),(-122.076983,37.22567),(-122.076599,37.22026),(-122.076229,37.21505),(-122.0758,37.209)]
|Oakland
> I- 880
|[(-122.0978,37.528),(-122.096,37.496),(-122.0931,37.453),(-122.09277,37.4496),(-122.090189,37.41442),(-122.0896,37.405),(-122.085,37.34)]
|Oakland
198a135
> I- 880
|[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
|Oakland
201a139,143
> I- 880 Ramp|[(-122.0019,37.301),(-122.002,37.293)]
|Oakland
> I- 880
Ramp|[(-122.0041,37.313),(-122.0018,37.315),(-122.0007,37.315),(-122.0005,37.313),(-122.0002,37.308),(-121.9995,37.289)]
|Oakland
> I- 880
Ramp|[(-122.0041,37.313),(-122.0038,37.308),(-122.0039,37.284),(-122.0013,37.287),(-121.9995,37.289)]
|Oakland
> I- 880
Ramp|[(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
|Oakland
> I- 880
Ramp|[(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
|Oakland
202a145,146
> I- 880
Ramp|[(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
|Oakland
> I- 880
Ramp|[(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
|Oakland
203a148,149
> I- 880
Ramp|[(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]
|Oakland
> I- 880
Ramp|[(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]
|Oakland
207a154,155
> I- 880 Ramp|[(-122.2771,37.002),(-122.278,37)]
|Lafayette
> Indian Way |[(-122.2066,37.398),(-122.2045,37.411)]
|Lafayette
208a157
> Johnson Dr |[(-121.9145,37.901),(-121.915,37.877)]
|Oakland
209a159,160
> Juniper St |[(-121.7823,37.897),(-121.7815,37.9)]
|Oakland
> Kaiser Dr
|[(-122.067163,37.47821),(-122.060402,37.51961)]
|Oakland
210a162,163
> Kildare Road|[(-122.0968,37.016),(-122.0959,37)]
|Oakland
> La Playa Dr |[(-122.1039,37.545),(-122.101,37.493)]
|Oakland
211a165
> Laguna Ave |[(-122.2099,37.989),(-122.2089,37)]
|Lafayette
213a168,169
> Lakeshore Ave |[(-122.2586,37.99),(-122.2556,37.006)]
|Lafayette
> Las Positas
Road|[(-121.764488,37.99199),(-121.75569,37.02022)]
|Oakland
214a171,174
> Linden St |[(-122.2867,37.998),(-122.2864,37.008)]
|Lafayette
> Livermore Ave |[(-121.7687,37.448),(-121.769,37.375)]
|Oakland
> Livermore Ave
|[(-121.772719,37.99085),(-121.7728,37.001)]
|Oakland
> Locust St |[(-122.1606,37.007),(-122.1593,37.987)]
|Oakland
215a176,177
> Magnolia St |[(-122.0971,37.5),(-122.0962,37.484)]
|Oakland
> Mandalay Road|[(-122.2322,37.397),(-122.2321,37.403)]
|Lafayette
217a180,181
> Mattos Dr
|[(-122.0005,37.502),(-122.000898,37.49683)]
|Oakland
> Maubert Ave |[(-122.1114,37.009),(-122.1096,37.995)]
|Oakland
218a183
> McClure Ave |[(-122.1431,37.001),(-122.1436,37.998)]
|Oakland
219a185
> Mildred Ct |[(-122.0002,37.388),(-121.9998,37.386)]
|Oakland
220a187,189
> Miramar Ave
|[(-122.1009,37.025),(-122.099089,37.03209)]
|Oakland
> Mission
Blvd|[(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]
|Oakland
> Mission
Blvd|[(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]
|Oakland
221a191,193
> Moores Ave |[(-122.0087,37.301),(-122.0094,37.292)]
|Oakland
> National Ave |[(-122.1192,37.5),(-122.1281,37.489)]
|Oakland
> Navajo Ct |[(-121.8779,37.901),(-121.8783,37.9)]
|Oakland
222a195
> Oakridge Road|[(-121.8316,37.049),(-121.828382,37)]
|Oakland
225a199
> Paseo Padre Pkwy|[(-121.9143,37.005),(-121.913522,37)]
|Oakland
227a202,207
> Periwinkle
Road|[(-122.0451,37.301),(-122.044758,37.29844)]
|Oakland
> Pimlico Dr |[(-121.8616,37.998),(-121.8618,37.008)]
|Oakland
> Portsmouth Ave |[(-122.1064,37.315),(-122.1064,37.308)]
|Oakland
> Proctor Ave |[(-122.2267,37.406),(-122.2251,37.386)]
|Lafayette
> Railroad Ave
|[(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
|Oakland
> Railroad Ave
|[(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
|Oakland
228a209,210
> Ranspot Dr |[(-122.0972,37.999),(-122.0959,37)]
|Oakland
> Ranspot Dr |[(-122.0972,37.999),(-122.0959,37)]
|Oakland
230a213
> Redwood Road|[(-122.1493,37.98),(-122.1437,37.001)]
|Oakland
232a216
> Rosedale Ct |[(-121.9232,37.9),(-121.924,37.897)]
|Oakland
234a219
> Saginaw Ct |[(-121.8803,37.898),(-121.8806,37.901)]
|Oakland
235a221,222
> Santa Maria Ave |[(-122.0773,37),(-122.0773,37.98)]
|Oakland
> Santa Maria Ave |[(-122.0773,37),(-122.0773,37.98)]
|Oakland
237a225
> Sheridan
Road|[(-122.2279,37.425),(-122.2253,37.411),(-122.2223,37.377)]
|Lafayette
238a227
> Skyline Blvd|[(-122.1738,37.01),(-122.1714,37.996)]
|Oakland
239a229
> Skyline Dr |[(-122.0277,37.5),(-122.0284,37.498)]
|Oakland
240a231,234
> Sp Railroad
|[(-121.893564,37.99009),(-121.897,37.016)]
|Oakland
> Sp Railroad |[(-121.9565,37.898),(-121.9562,37.9)]
|Oakland
> Sp Railroad |[(-122.0734,37.001),(-122.0734,37.997)]
|Oakland
> Sp Railroad |[(-122.0734,37.001),(-122.0734,37.997)]
|Oakland
242a237
> Sp Railroad
|[(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]
|Oakland
243a239,240
> Sp Railroad
|[(-122.1947,37.497),(-122.193328,37.4848)]
|Oakland
> Stanton Ave
|[(-122.100392,37.0697),(-122.099513,37.06052)]
|Oakland
245a243,244
> State Hwy 13
|[(-122.2049,37.2),(-122.20328,37.17975),(-122.1989,37.125),(-122.198078,37.11641),(-122.1975,37.11)]
|Lafayette
> State Hwy 13
Ramp|[(-122.2244,37.427),(-122.223,37.414),(-122.2214,37.396),(-122.2213,37.388)]
|Lafayette
247a247,250
> State Hwy 24
|[(-122.2674,37.246),(-122.2673,37.248),(-122.267,37.261),(-122.2668,37.271),(-122.2663,37.298),(-122.2659,37.315),(-122.2655,37.336),(-122.265007,37.35882),(-122.264443,37.37286),(-122.2641,37.381),(-122.2638,37.388),(-122.2631,37.396),(-122.2617,37.405),(-122.2615,37.407),(-122.2605,37.412)]
|Lafayette
> State Hwy 84
|[(-121.9565,37.898),(-121.956589,37.89911),(-121.9569,37.903),(-121.956,37.91),(-121.9553,37.919)]
|Oakland
> State Hwy 92
|[(-122.1085,37.326),(-122.1095,37.322),(-122.1111,37.316),(-122.1119,37.313),(-122.1125,37.311),(-122.1131,37.308),(-122.1167,37.292),(-122.1187,37.285),(-122.12,37.28)]
|Oakland
> State Hwy 92
Ramp|[(-122.1086,37.321),(-122.1089,37.315),(-122.1111,37.316)]
|Oakland
248a252,258
> Sunol Ridge Trl |[(-121.9419,37.455),(-121.9345,37.38)]
|Oakland
> Tassajara Creek
|[(-121.87866,37.98898),(-121.8782,37.015)]
|Oakland
> Taurus Ave |[(-122.2159,37.416),(-122.2128,37.389)]
|Lafayette
> Thackeray Ave |[(-122.072,37.305),(-122.0715,37.298)]
|Oakland
> Theresa Way |[(-121.7289,37.906),(-121.728,37.899)]
|Oakland
> Tissiack Way |[(-121.920364,37),(-121.9208,37.995)]
|Oakland
> Tissiack Way |[(-121.920364,37),(-121.9208,37.995)]
|Oakland
249a260,263
> Vallecitos Road|[(-121.8699,37.916),(-121.8703,37.891)]
|Oakland
> Warm Springs Blvd|[(-121.933956,37),(-121.9343,37.97)]
|Oakland
> Warm Springs Blvd|[(-121.933956,37),(-121.9343,37.97)]
|Oakland
> Welch Creek Road|[(-121.7695,37.386),(-121.7737,37.413)]
|Oakland
250a265,266
> Western Pacific Railroad Spur |[(-122.0394,37.018),(-122.0394,37.961)]
|Oakland
> Western Pacific Railroad Spur |[(-122.0394,37.018),(-122.0394,37.961)]
|Oakland
251a268,271
> Whitlock Creek
|[(-121.74683,37.91276),(-121.733107,37)]
|Oakland
> Whitlock Creek
|[(-121.74683,37.91276),(-121.733107,37)]
|Oakland
> Willimet Way |[(-122.0964,37.517),(-122.0949,37.493)]
|Oakland
> Wisconsin St
|[(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]
|Oakland
253a274,275
> 100th Ave |[(-122.1657,37.429),(-122.1647,37.432)]
|Oakland
> 107th Ave |[(-122.1555,37.403),(-122.1531,37.41)]
|Oakland
254a277,278
> 1st St
|[(-121.75508,37.89294),(-121.753581,37.90031)]
|Oakland
> 5th St
|[(-122.278,37),(-122.2792,37.005),(-122.2803,37.009)]
|Lafayette
257,284c281,284
< Ada St |[(-122.2487,37.398),(-122.2496,37.401)]
|Lafayette
< California St |[(-122.2032,37.005),(-122.2016,37.996)]
|Lafayette
< Capricorn Ave |[(-122.2176,37.404),(-122.2164,37.384)]
|Lafayette
< Chambers Dr |[(-122.2004,37.352),(-122.1972,37.368)]
|Lafayette
< Chambers Lane|[(-122.2001,37.359),(-122.1975,37.371)]
|Lafayette
< Champion St |[(-122.214,37.991),(-122.2147,37.002)]
|Lafayette
< Coolidge Ave |[(-122.2007,37.058),(-122.1992,37.06)]
|Lafayette
< Creston
Road|[(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]
|Lafayette
< Dimond Ave |[(-122.2167,37.994),(-122.2162,37.006)]
|Lafayette
< Edgewater Dr |[(-122.201,37.379),(-122.2042,37.41)]
|Lafayette
< Euclid Ave |[(-122.2671,37.009),(-122.2666,37.987)]
|Lafayette
< Heartwood Dr |[(-122.2006,37.341),(-122.1992,37.338)]
|Lafayette
< Hollis St |[(-122.2885,37.397),(-122.289,37.414)]
|Lafayette
< I- 580
|[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]
|Lafayette
< I- 80
Ramp|[(-122.2962,37.413),(-122.2959,37.382),(-122.2951,37.372)]
|Lafayette
< I- 880 Ramp|[(-122.2771,37.002),(-122.278,37)]
|Lafayette
< Indian Way |[(-122.2066,37.398),(-122.2045,37.411)]
|Lafayette
< Laguna Ave |[(-122.2099,37.989),(-122.2089,37)]
|Lafayette
< Lakeshore Ave |[(-122.2586,37.99),(-122.2556,37.006)]
|Lafayette
< Linden St |[(-122.2867,37.998),(-122.2864,37.008)]
|Lafayette
< Mandalay Road|[(-122.2322,37.397),(-122.2321,37.403)]
|Lafayette
< Proctor Ave |[(-122.2267,37.406),(-122.2251,37.386)]
|Lafayette
< Sheridan
Road|[(-122.2279,37.425),(-122.2253,37.411),(-122.2223,37.377)]
|Lafayette
< State Hwy 13
|[(-122.2049,37.2),(-122.20328,37.17975),(-122.1989,37.125),(-122.198078,37.11641),(-122.1975,37.11)]
|Lafayette
< State Hwy 13
Ramp|[(-122.2244,37.427),(-122.223,37.414),(-122.2214,37.396),(-122.2213,37.388)]
|Lafayette
< State Hwy 24
|[(-122.2674,37.246),(-122.2673,37.248),(-122.267,37.261),(-122.2668,37.271),(-122.2663,37.298),(-122.2659,37.315),(-122.2655,37.336),(-122.265007,37.35882),(-122.264443,37.37286),(-122.2641,37.381),(-122.2638,37.388),(-122.2631,37.396),(-122.2617,37.405),(-122.2615,37.407),(-122.2605,37.412)]
|Lafayette
< Taurus Ave |[(-122.2159,37.416),(-122.2128,37.389)]
|Lafayette
< 5th St
|[(-122.278,37),(-122.2792,37.005),(-122.2803,37.009)]
|Lafayette
---
> 85th Ave |[(-122.1877,37.466),(-122.186,37.476)]
|Oakland
> 89th Ave |[(-122.1822,37.459),(-122.1803,37.471)]
|Oakland
> 98th Ave |[(-122.1568,37.498),(-122.1558,37.502)]
|Oakland
> 98th Ave |[(-122.1693,37.438),(-122.1682,37.444)]
|Oakland
[dave@morpheus regress]#
[dave@morpheus regress]# diff expected/rules.out results/rules.out
1068,1090c1068,1070
< viewname |definition
<
------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
< iexit |SELECT "ih"."name", "ih"."thepath",
"interpt_pp"("ih"."thepath", "r"."thepath") AS "exit" FROM "ihighway" "ih",
"ramp" "r" WHERE ("ih"."thepath" ## "r"."thepath");
< pg_indexes |SELECT "c"."relname" AS "tablename", "i"."relname" AS
"indexname", "pg_get_indexdef"("x"."indexrelid") AS "indexdef" FROM
"pg_index" "x", "pg_class" "c", "pg_class" "i" WHERE (("c"."oid" =
"x"."indrelid") AND ("i"."oid" = "x"."indexrelid"));
< pg_rules |SELECT "c"."relname" AS "tablename", "r"."rulename",
"pg_get_ruledef"("r"."rulename") AS "definition" FROM "pg_rewrite" "r",
"pg_class" "c" WHERE (("r"."rulename" !~ '^_RET'::"text") AND ("c"."oid" =
"r"."ev_class"));
< pg_tables |SELECT "c"."relname" AS "tablename",
"pg_get_userbyid"("c"."relowner") AS "tableowner", "c"."relhasindex" AS
"hasindexes", "c"."relhasrules" AS "hasrules", ("c"."reltriggers" >
'0'::"int4") AS "hastriggers" FROM "pg_class" "c" WHERE ((("c"."relkind" =
'r'::"char") OR ("c"."relkind" = 's'::"char")) AND (NOT (EXISTS (SELECT
"pg_rewrite"."rulename" FROM "pg_rewrite" WHERE (("pg_rewrite"."ev_class" =
"c"."oid") AND ("pg_rewrite"."ev_type" = '1'::"char"))))));
< pg_user |SELECT "pg_shadow"."usename", "pg_shadow"."usesysid",
"pg_shadow"."usecreatedb", "pg_shadow"."usetrace", "pg_shadow"."usesuper",
"pg_shadow"."usecatupd", '********'::"text" AS "passwd",
"pg_shadow"."valuntil" FROM "pg_shadow";
< pg_views |SELECT "c"."relname" AS "viewname",
"pg_get_userbyid"("c"."relowner") AS "viewowner",
"pg_get_viewdef"("c"."relname") AS "definition" FROM "pg_class" "c" WHERE
("c"."relhasrules" AND (EXISTS (SELECT "r"."rulename" FROM "pg_rewrite" "r"
WHERE (("r"."ev_class" = "c"."oid") AND ("r"."ev_type" = '1'::"char")))));
< rtest_v1 |SELECT "rtest_t1"."a", "rtest_t1"."b" FROM "rtest_t1";
< rtest_vcomp |SELECT "x"."part", ("x"."size" * "y"."factor") AS
"size_in_cm" FROM "rtest_comp" "x", "rtest_unitfact" "y" WHERE ("x"."unit" =
"y"."unit");
< rtest_vview1 |SELECT "x"."a", "x"."b" FROM "rtest_view1" "x" WHERE
('0'::"int4" < (SELECT "count"("y"."a") AS "count" FROM "rtest_view2" "y"
WHERE ("y"."a" = "x"."a")));
< rtest_vview2 |SELECT "rtest_view1"."a", "rtest_view1"."b" FROM
"rtest_view1" WHERE "rtest_view1"."v";
< rtest_vview3 |SELECT "x"."a", "x"."b" FROM "rtest_vview2" "x" WHERE
('0'::"int4" < (SELECT "count"("y"."a") AS "count" FROM "rtest_view2" "y"
WHERE ("y"."a" = "x"."a")));
< rtest_vview4 |SELECT "x"."a", "x"."b", "count"("y"."a") AS "refcount"
FROM "rtest_view1" "x", "rtest_view2" "y" WHERE ("x"."a" = "y"."a") GROUP BY
"x"."a", "x"."b";
< rtest_vview5 |SELECT "rtest_view1"."a", "rtest_view1"."b",
"rtest_viewfunc1"("rtest_view1"."a") AS "refcount" FROM "rtest_view1";
< shoe |SELECT "sh"."shoename", "sh"."sh_avail",
"sh"."slcolor", "sh"."slminlen", ("sh"."slminlen" * "un"."un_fact") AS
"slminlen_cm", "sh"."slmaxlen", ("sh"."slmaxlen" * "un"."un_fact") AS
"slmaxlen_cm", "sh"."slunit" FROM "shoe_data" "sh", "unit" "un" WHERE
("sh"."slunit" = "un"."un_name");
< shoe_ready |SELECT "rsh"."shoename", "rsh"."sh_avail",
"rsl"."sl_name", "rsl"."sl_avail", "int4smaller"("rsh"."sh_avail",
"rsl"."sl_avail") AS "total_avail" FROM "shoe" "rsh", "shoelace" "rsl" WHERE
((("rsl"."sl_color" = "rsh"."slcolor") AND ("rsl"."sl_len_cm" >=
"rsh"."slminlen_cm")) AND ("rsl"."sl_len_cm" <= "rsh"."slmaxlen_cm"));
< shoelace |SELECT "s"."sl_name", "s"."sl_avail", "s"."sl_color",
"s"."sl_len", "s"."sl_unit", ("s"."sl_len" * "u"."un_fact") AS "sl_len_cm"
FROM "shoelace_data" "s", "unit" "u" WHERE ("s"."sl_unit" = "u"."un_name");
< shoelace_candelete|SELECT "shoelace_obsolete"."sl_name",
"shoelace_obsolete"."sl_avail", "shoelace_obsolete"."sl_color",
"shoelace_obsolete"."sl_len", "shoelace_obsolete"."sl_unit",
"shoelace_obsolete"."sl_len_cm" FROM "shoelace_obsolete" WHERE
("shoelace_obsolete"."sl_avail" = '0'::"int4");
< shoelace_obsolete |SELECT "shoelace"."sl_name", "shoelace"."sl_avail",
"shoelace"."sl_color", "shoelace"."sl_len", "shoelace"."sl_unit",
"shoelace"."sl_len_cm" FROM "shoelace" WHERE (NOT (EXISTS (SELECT
"shoe"."shoename" FROM "shoe" WHERE ("shoe"."slcolor" =
"shoelace"."sl_color"))));
< street |SELECT "r"."name", "r"."thepath", "c"."cname" FROM
"road" "r", "real_city" "c" WHERE ("c"."outline" ## "r"."thepath");
< toyemp |SELECT "emp"."name", "emp"."age", "emp"."location",
('12'::"int4" * "emp"."salary") AS "annualsal" FROM "emp";
< (20 rows)
---
> viewname|definition
> --------+----------
> (0 rows)
1094,1123c1074,1076
< tablename |rulename |definition
<
-------------+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
< rtest_emp |rtest_emp_del |CREATE RULE "rtest_emp_del" AS ON DELETE TO
"rtest_emp" DO INSERT INTO "rtest_emplog" ("ename", "who", "action",
"newsal", "oldsal") VALUES (old."ename", "getpgusername"(),
'fired'::"bpchar", '$0.00'::"money", old."salary");
< rtest_emp |rtest_emp_ins |CREATE RULE "rtest_emp_ins" AS ON INSERT TO
"rtest_emp" DO INSERT INTO "rtest_emplog" ("ename", "who", "action",
"newsal", "oldsal") VALUES (new."ename", "getpgusername"(),
'hired'::"bpchar", new."salary", '$0.00'::"money");
< rtest_emp |rtest_emp_upd |CREATE RULE "rtest_emp_upd" AS ON UPDATE TO
"rtest_emp" WHERE (new."salary" <> old."salary") DO INSERT INTO
"rtest_emplog" ("ename", "who", "action", "newsal", "oldsal") VALUES
(new."ename", "getpgusername"(), 'honored'::"bpchar", new."salary",
old."salary");
< rtest_nothn1 |rtest_nothn_r1 |CREATE RULE "rtest_nothn_r1" AS ON INSERT TO
"rtest_nothn1" WHERE ((new."a" >= '10'::"int4") AND (new."a" <
'20'::"int4")) DO INSTEAD SELECT '1'::"int4";
< rtest_nothn1 |rtest_nothn_r2 |CREATE RULE "rtest_nothn_r2" AS ON INSERT TO
"rtest_nothn1" WHERE ((new."a" >= '30'::"int4") AND (new."a" <
'40'::"int4")) DO INSTEAD NOTHING;
< rtest_nothn2 |rtest_nothn_r3 |CREATE RULE "rtest_nothn_r3" AS ON INSERT TO
"rtest_nothn2" WHERE (new."a" >= '100'::"int4") DO INSTEAD INSERT INTO
"rtest_nothn3" ("a", "b") VALUES (new."a", new."b");
< rtest_nothn2 |rtest_nothn_r4 |CREATE RULE "rtest_nothn_r4" AS ON INSERT TO
"rtest_nothn2" DO INSTEAD NOTHING;
< rtest_order1 |rtest_order_r1 |CREATE RULE "rtest_order_r1" AS ON INSERT TO
"rtest_order1" DO INSTEAD INSERT INTO "rtest_order2" ("a", "b", "c") VALUES
(new."a", "nextval"('rtest_seq'::"text"), 'rule 1 - this should run 3rd or
4th'::"text");
< rtest_order1 |rtest_order_r2 |CREATE RULE "rtest_order_r2" AS ON INSERT TO
"rtest_order1" DO INSERT INTO "rtest_order2" ("a", "b", "c") VALUES
(new."a", "nextval"('rtest_seq'::"text"), 'rule 2 - this should run
1st'::"text");
< rtest_order1 |rtest_order_r3 |CREATE RULE "rtest_order_r3" AS ON INSERT TO
"rtest_order1" DO INSTEAD INSERT INTO "rtest_order2" ("a", "b", "c") VALUES
(new."a", "nextval"('rtest_seq'::"text"), 'rule 3 - this should run 3rd or
4th'::"text");
< rtest_order1 |rtest_order_r4 |CREATE RULE "rtest_order_r4" AS ON INSERT TO
"rtest_order1" WHERE ("rtest_order2"."a" < '100'::"int4") DO INSTEAD INSERT
INTO "rtest_order2" ("a", "b", "c") VALUES (new."a",
"nextval"('rtest_seq'::"text"), 'rule 4 - this should run 2nd'::"text");
< rtest_person |rtest_pers_del |CREATE RULE "rtest_pers_del" AS ON DELETE TO
"rtest_person" DO DELETE FROM "rtest_admin" WHERE ("rtest_admin"."pname" =
old."pname");
< rtest_person |rtest_pers_upd |CREATE RULE "rtest_pers_upd" AS ON UPDATE TO
"rtest_person" DO UPDATE rtest_admin SET "pname" = new."pname" WHERE
("rtest_admin"."pname" = old."pname");
< rtest_system |rtest_sys_del |CREATE RULE "rtest_sys_del" AS ON DELETE TO
"rtest_system" DO (DELETE FROM "rtest_interface" WHERE
("rtest_interface"."sysname" = old."sysname"); DELETE FROM "rtest_admin"
WHERE ("rtest_admin"."sysname" = old."sysname"); );
< rtest_system |rtest_sys_upd |CREATE RULE "rtest_sys_upd" AS ON UPDATE TO
"rtest_system" DO (UPDATE rtest_interface SET "sysname" = new."sysname" WHERE
("rtest_interface"."sysname" = old."sysname"); UPDATE rtest_admin SET
"sysname" = new."sysname" WHERE ("rtest_admin"."sysname" = old."sysname"); );
< rtest_t4 |rtest_t4_ins1 |CREATE RULE "rtest_t4_ins1" AS ON INSERT TO
"rtest_t4" WHERE ((new."a" >= '10'::"int4") AND (new."a" < '20'::"int4")) DO
INSTEAD INSERT INTO "rtest_t5" ("a", "b") VALUES (new."a", new."b");
< rtest_t4 |rtest_t4_ins2 |CREATE RULE "rtest_t4_ins2" AS ON INSERT TO
"rtest_t4" WHERE ((new."a" >= '20'::"int4") AND (new."a" < '30'::"int4")) DO
INSERT INTO "rtest_t6" ("a", "b") VALUES (new."a", new."b");
< rtest_t5 |rtest_t5_ins |CREATE RULE "rtest_t5_ins" AS ON INSERT TO
"rtest_t5" WHERE (new."a" > '15'::"int4") DO INSERT INTO "rtest_t7" ("a",
"b") VALUES (new."a", new."b");
< rtest_t6 |rtest_t6_ins |CREATE RULE "rtest_t6_ins" AS ON INSERT TO
"rtest_t6" WHERE (new."a" > '25'::"int4") DO INSTEAD INSERT INTO "rtest_t8"
("a", "b") VALUES (new."a", new."b");
< rtest_v1 |rtest_v1_del |CREATE RULE "rtest_v1_del" AS ON DELETE TO
"rtest_v1" DO INSTEAD DELETE FROM "rtest_t1" WHERE ("rtest_t1"."a" =
old."a");
< rtest_v1 |rtest_v1_ins |CREATE RULE "rtest_v1_ins" AS ON INSERT TO
"rtest_v1" DO INSTEAD INSERT INTO "rtest_t1" ("a", "b") VALUES (new."a",
new."b");
< rtest_v1 |rtest_v1_upd |CREATE RULE "rtest_v1_upd" AS ON UPDATE TO
"rtest_v1" DO INSTEAD UPDATE rtest_t1 SET "a" = new."a", "b" = new."b" WHERE
("rtest_t1"."a" = old."a");
< shoelace |shoelace_del |CREATE RULE "shoelace_del" AS ON DELETE TO
"shoelace" DO INSTEAD DELETE FROM "shoelace_data" WHERE
("shoelace_data"."sl_name" = old."sl_name");
< shoelace |shoelace_ins |CREATE RULE "shoelace_ins" AS ON INSERT TO
"shoelace" DO INSTEAD INSERT INTO "shoelace_data" ("sl_name", "sl_avail",
"sl_color", "sl_len", "sl_unit") VALUES (new."sl_name", new."sl_avail",
new."sl_color", new."sl_len", new."sl_unit");
< shoelace |shoelace_upd |CREATE RULE "shoelace_upd" AS ON UPDATE TO
"shoelace" DO INSTEAD UPDATE shoelace_data SET "sl_name" = new."sl_name",
"sl_avail" = new."sl_avail", "sl_color" = new."sl_color", "sl_len" =
new."sl_len", "sl_unit" = new."sl_unit" WHERE ("shoelace_data"."sl_name" =
old."sl_name");
< shoelace_data|log_shoelace |CREATE RULE "log_shoelace" AS ON UPDATE TO
"shoelace_data" WHERE (new."sl_avail" <> old."sl_avail") DO INSERT INTO
"shoelace_log" ("sl_name", "sl_avail", "log_who", "log_when") VALUES
(new."sl_name", new."sl_avail", 'Al Bundy'::"name",
"datetime"('epoch'::"text"));
< shoelace_ok |shoelace_ok_ins|CREATE RULE "shoelace_ok_ins" AS ON INSERT
TO "shoelace_ok" DO INSTEAD UPDATE shoelace SET "sl_avail" =
("shoelace"."sl_avail" + new."ok_quant") WHERE ("shoelace"."sl_name" =
new."ok_name");
< (27 rows)
---
> tablename|rulename|definition
> ---------+--------+----------
> (0 rows)
[dave@morpheus regress]#
