diff options
Diffstat (limited to 'src/test/regress/expected/boolean.out')
-rw-r--r-- | src/test/regress/expected/boolean.out | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/test/regress/expected/boolean.out b/src/test/regress/expected/boolean.out index 06f2fac16b5..93e475b673f 100644 --- a/src/test/regress/expected/boolean.out +++ b/src/test/regress/expected/boolean.out @@ -59,7 +59,7 @@ INSERT INTO BOOLTBL1 (f1) VALUES (bool 't'); INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True'); INSERT INTO BOOLTBL1 (f1) VALUES (bool 'true'); -- BOOLTBL1 should be full of true's at this point -SELECT '' AS t_3, BOOLTBL1.*; +SELECT '' AS t_3, BOOLTBL1.* FROM BOOLTBL1; t_3 | f1 -----+---- | t @@ -114,7 +114,7 @@ INSERT INTO BOOLTBL2 (f1) VALUES (bool 'XXX'); ERROR: invalid input syntax for type boolean: "XXX" -- BOOLTBL2 should be full of false's at this point -SELECT '' AS f_4, BOOLTBL2.*; +SELECT '' AS f_4, BOOLTBL2.* FROM BOOLTBL2; f_4 | f1 -----+---- | f @@ -124,6 +124,7 @@ SELECT '' AS f_4, BOOLTBL2.*; (4 rows) SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.* + FROM BOOLTBL1, BOOLTBL2 WHERE BOOLTBL2.f1 <> BOOLTBL1.f1; tf_12 | f1 | f1 -------+----+---- @@ -142,6 +143,7 @@ SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.* (12 rows) SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.* + FROM BOOLTBL1, BOOLTBL2 WHERE boolne(BOOLTBL2.f1,BOOLTBL1.f1); tf_12 | f1 | f1 -------+----+---- @@ -160,6 +162,7 @@ SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.* (12 rows) SELECT '' AS ff_4, BOOLTBL1.*, BOOLTBL2.* + FROM BOOLTBL1, BOOLTBL2 WHERE BOOLTBL2.f1 = BOOLTBL1.f1 and BOOLTBL1.f1 = bool 'false'; ff_4 | f1 | f1 ------+----+---- @@ -170,6 +173,7 @@ SELECT '' AS ff_4, BOOLTBL1.*, BOOLTBL2.* (4 rows) SELECT '' AS tf_12_ff_4, BOOLTBL1.*, BOOLTBL2.* + FROM BOOLTBL1, BOOLTBL2 WHERE BOOLTBL2.f1 = BOOLTBL1.f1 or BOOLTBL1.f1 = bool 'true' ORDER BY BOOLTBL1.f1, BOOLTBL2.f1; tf_12_ff_4 | f1 | f1 |