1
1
--
2
- --replace
3
- --
2
+ --MISC
3
+
4
4
--
5
5
-- BTREE
6
6
--
@@ -86,11 +86,11 @@ SELECT * FROM a_star*;
86
86
87
87
SELECT *
88
88
FROM b_star* x
89
- WHERE x.b = 'bumble'::text or x.a < 3;
89
+ WHERE x.b =text 'bumble' or x.a < 3;
90
90
91
91
SELECT class, a
92
92
FROM c_star* x
93
- WHERE x.c ~ 'hi'::text ;
93
+ WHERE x.c ~text 'hi';
94
94
95
95
SELECT class, b, c
96
96
FROM d_star* x
@@ -148,7 +148,7 @@ SELECT * FROM e_star*;
148
148
ALTER TABLE a_star* ADD COLUMN a text;
149
149
150
150
--UPDATE b_star*
151
- -- SET a = 'gazpacho'::text
151
+ -- SET a =text 'gazpacho'
152
152
-- WHERE aa > 4;
153
153
154
154
SELECT class, aa, a FROM a_star*;
@@ -208,7 +208,7 @@ SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM person* p;
208
208
SELECT user_relns() AS user_relns
209
209
ORDER BY user_relns;
210
210
211
- --SELECT name(equipment(hobby_construct('skywalking'::text, 'mer'::text ))) AS equip_name;
211
+ --SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))) AS equip_name;
212
212
213
213
214
214
--
@@ -222,3 +222,4 @@ SELECT user_relns() AS user_relns
222
222
--
223
223
-- rewrite rules
224
224
--
225
+