Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitafa0d53

Browse files
committed
Improve whitespace
The SQL file was using a mix of tabs and spaces inconsistently.Convert all to spaces and adjust indentation accordingly.
1 parent560d260 commitafa0d53

File tree

2 files changed

+134
-134
lines changed

2 files changed

+134
-134
lines changed

‎src/test/regress/expected/hash_func.out

Lines changed: 67 additions & 67 deletions
Original file line numberDiff line numberDiff line change
@@ -16,8 +16,8 @@ WHERE hashint2(v)::bit(32) != hashint2extended(v, 0)::bit(32)
1616
(0 rows)
1717

1818
SELECT v as value, hashint4(v)::bit(32) as standard,
19-
hashint4extended(v, 0)::bit(32) as extended0,
20-
hashint4extended(v, 1)::bit(32) as extended1
19+
hashint4extended(v, 0)::bit(32) as extended0,
20+
hashint4extended(v, 1)::bit(32) as extended1
2121
FROM (VALUES (0), (1), (17), (42), (550273), (207112489)) x(v)
2222
WHERE hashint4(v)::bit(32) != hashint4extended(v, 0)::bit(32)
2323
OR hashint4(v)::bit(32) = hashint4extended(v, 1)::bit(32);
@@ -26,8 +26,8 @@ WHERE hashint4(v)::bit(32) != hashint4extended(v, 0)::bit(32)
2626
(0 rows)
2727

2828
SELECT v as value, hashint8(v)::bit(32) as standard,
29-
hashint8extended(v, 0)::bit(32) as extended0,
30-
hashint8extended(v, 1)::bit(32) as extended1
29+
hashint8extended(v, 0)::bit(32) as extended0,
30+
hashint8extended(v, 1)::bit(32) as extended1
3131
FROM (VALUES (0), (1), (17), (42), (550273), (207112489)) x(v)
3232
WHERE hashint8(v)::bit(32) != hashint8extended(v, 0)::bit(32)
3333
OR hashint8(v)::bit(32) = hashint8extended(v, 1)::bit(32);
@@ -36,8 +36,8 @@ WHERE hashint8(v)::bit(32) != hashint8extended(v, 0)::bit(32)
3636
(0 rows)
3737

3838
SELECT v as value, hashfloat4(v)::bit(32) as standard,
39-
hashfloat4extended(v, 0)::bit(32) as extended0,
40-
hashfloat4extended(v, 1)::bit(32) as extended1
39+
hashfloat4extended(v, 0)::bit(32) as extended0,
40+
hashfloat4extended(v, 1)::bit(32) as extended1
4141
FROM (VALUES (0), (1), (17), (42), (550273), (207112489)) x(v)
4242
WHERE hashfloat4(v)::bit(32) != hashfloat4extended(v, 0)::bit(32)
4343
OR hashfloat4(v)::bit(32) = hashfloat4extended(v, 1)::bit(32);
@@ -46,8 +46,8 @@ WHERE hashfloat4(v)::bit(32) != hashfloat4extended(v, 0)::bit(32)
4646
(0 rows)
4747

4848
SELECT v as value, hashfloat8(v)::bit(32) as standard,
49-
hashfloat8extended(v, 0)::bit(32) as extended0,
50-
hashfloat8extended(v, 1)::bit(32) as extended1
49+
hashfloat8extended(v, 0)::bit(32) as extended0,
50+
hashfloat8extended(v, 1)::bit(32) as extended1
5151
FROM (VALUES (0), (1), (17), (42), (550273), (207112489)) x(v)
5252
WHERE hashfloat8(v)::bit(32) != hashfloat8extended(v, 0)::bit(32)
5353
OR hashfloat8(v)::bit(32) = hashfloat8extended(v, 1)::bit(32);
@@ -56,8 +56,8 @@ WHERE hashfloat8(v)::bit(32) != hashfloat8extended(v, 0)::bit(32)
5656
(0 rows)
5757

5858
SELECT v as value, hashoid(v)::bit(32) as standard,
59-
hashoidextended(v, 0)::bit(32) as extended0,
60-
hashoidextended(v, 1)::bit(32) as extended1
59+
hashoidextended(v, 0)::bit(32) as extended0,
60+
hashoidextended(v, 1)::bit(32) as extended1
6161
FROM (VALUES (0), (1), (17), (42), (550273), (207112489)) x(v)
6262
WHERE hashoid(v)::bit(32) != hashoidextended(v, 0)::bit(32)
6363
OR hashoid(v)::bit(32) = hashoidextended(v, 1)::bit(32);
@@ -66,8 +66,8 @@ WHERE hashoid(v)::bit(32) != hashoidextended(v, 0)::bit(32)
6666
(0 rows)
6767

6868
SELECT v as value, hashchar(v)::bit(32) as standard,
69-
hashcharextended(v, 0)::bit(32) as extended0,
70-
hashcharextended(v, 1)::bit(32) as extended1
69+
hashcharextended(v, 0)::bit(32) as extended0,
70+
hashcharextended(v, 1)::bit(32) as extended1
7171
FROM (VALUES (NULL::"char"), ('1'), ('x'), ('X'), ('p'), ('N')) x(v)
7272
WHERE hashchar(v)::bit(32) != hashcharextended(v, 0)::bit(32)
7373
OR hashchar(v)::bit(32) = hashcharextended(v, 1)::bit(32);
@@ -76,30 +76,30 @@ WHERE hashchar(v)::bit(32) != hashcharextended(v, 0)::bit(32)
7676
(0 rows)
7777

7878
SELECT v as value, hashname(v)::bit(32) as standard,
79-
hashnameextended(v, 0)::bit(32) as extended0,
80-
hashnameextended(v, 1)::bit(32) as extended1
79+
hashnameextended(v, 0)::bit(32) as extended0,
80+
hashnameextended(v, 1)::bit(32) as extended1
8181
FROM (VALUES (NULL), ('PostgreSQL'), ('eIpUEtqmY89'), ('AXKEJBTK'),
82-
('muop28x03'), ('yi3nm0d73')) x(v)
82+
('muop28x03'), ('yi3nm0d73')) x(v)
8383
WHERE hashname(v)::bit(32) != hashnameextended(v, 0)::bit(32)
8484
OR hashname(v)::bit(32) = hashnameextended(v, 1)::bit(32);
8585
value | standard | extended0 | extended1
8686
-------+----------+-----------+-----------
8787
(0 rows)
8888

8989
SELECT v as value, hashtext(v)::bit(32) as standard,
90-
hashtextextended(v, 0)::bit(32) as extended0,
91-
hashtextextended(v, 1)::bit(32) as extended1
90+
hashtextextended(v, 0)::bit(32) as extended0,
91+
hashtextextended(v, 1)::bit(32) as extended1
9292
FROM (VALUES (NULL), ('PostgreSQL'), ('eIpUEtqmY89'), ('AXKEJBTK'),
93-
('muop28x03'), ('yi3nm0d73')) x(v)
93+
('muop28x03'), ('yi3nm0d73')) x(v)
9494
WHERE hashtext(v)::bit(32) != hashtextextended(v, 0)::bit(32)
9595
OR hashtext(v)::bit(32) = hashtextextended(v, 1)::bit(32);
9696
value | standard | extended0 | extended1
9797
-------+----------+-----------+-----------
9898
(0 rows)
9999

100100
SELECT v as value, hashoidvector(v)::bit(32) as standard,
101-
hashoidvectorextended(v, 0)::bit(32) as extended0,
102-
hashoidvectorextended(v, 1)::bit(32) as extended1
101+
hashoidvectorextended(v, 0)::bit(32) as extended0,
102+
hashoidvectorextended(v, 1)::bit(32) as extended1
103103
FROM (VALUES (NULL::oidvector), ('0 1 2 3 4'), ('17 18 19 20'),
104104
('42 43 42 45'), ('550273 550273 570274'),
105105
('207112489 207112499 21512 2155 372325 1363252')) x(v)
@@ -110,8 +110,8 @@ WHERE hashoidvector(v)::bit(32) != hashoidvectorextended(v, 0)::bit(32)
110110
(0 rows)
111111

112112
SELECT v as value, hash_aclitem(v)::bit(32) as standard,
113-
hash_aclitem_extended(v, 0)::bit(32) as extended0,
114-
hash_aclitem_extended(v, 1)::bit(32) as extended1
113+
hash_aclitem_extended(v, 0)::bit(32) as extended0,
114+
hash_aclitem_extended(v, 1)::bit(32) as extended1
115115
FROM (SELECT DISTINCT(relacl[1]) FROM pg_class LIMIT 10) x(v)
116116
WHERE hash_aclitem(v)::bit(32) != hash_aclitem_extended(v, 0)::bit(32)
117117
OR hash_aclitem(v)::bit(32) = hash_aclitem_extended(v, 1)::bit(32);
@@ -120,10 +120,10 @@ WHERE hash_aclitem(v)::bit(32) != hash_aclitem_extended(v, 0)::bit(32)
120120
(0 rows)
121121

122122
SELECT v as value, hashmacaddr(v)::bit(32) as standard,
123-
hashmacaddrextended(v, 0)::bit(32) as extended0,
124-
hashmacaddrextended(v, 1)::bit(32) as extended1
123+
hashmacaddrextended(v, 0)::bit(32) as extended0,
124+
hashmacaddrextended(v, 1)::bit(32) as extended1
125125
FROM (VALUES (NULL::macaddr), ('08:00:2b:01:02:04'), ('08:00:2b:01:02:04'),
126-
('e2:7f:51:3e:70:49'), ('d6:a9:4a:78:1c:d5'),
126+
('e2:7f:51:3e:70:49'), ('d6:a9:4a:78:1c:d5'),
127127
('ea:29:b1:5e:1f:a5')) x(v)
128128
WHERE hashmacaddr(v)::bit(32) != hashmacaddrextended(v, 0)::bit(32)
129129
OR hashmacaddr(v)::bit(32) = hashmacaddrextended(v, 1)::bit(32);
@@ -132,19 +132,19 @@ WHERE hashmacaddr(v)::bit(32) != hashmacaddrextended(v, 0)::bit(32)
132132
(0 rows)
133133

134134
SELECT v as value, hashinet(v)::bit(32) as standard,
135-
hashinetextended(v, 0)::bit(32) as extended0,
136-
hashinetextended(v, 1)::bit(32) as extended1
135+
hashinetextended(v, 0)::bit(32) as extended0,
136+
hashinetextended(v, 1)::bit(32) as extended1
137137
FROM (VALUES (NULL::inet), ('192.168.100.128/25'), ('192.168.100.0/8'),
138-
('172.168.10.126/16'), ('172.18.103.126/24'), ('192.188.13.16/32')) x(v)
138+
('172.168.10.126/16'), ('172.18.103.126/24'), ('192.188.13.16/32')) x(v)
139139
WHERE hashinet(v)::bit(32) != hashinetextended(v, 0)::bit(32)
140140
OR hashinet(v)::bit(32) = hashinetextended(v, 1)::bit(32);
141141
value | standard | extended0 | extended1
142142
-------+----------+-----------+-----------
143143
(0 rows)
144144

145145
SELECT v as value, hash_numeric(v)::bit(32) as standard,
146-
hash_numeric_extended(v, 0)::bit(32) as extended0,
147-
hash_numeric_extended(v, 1)::bit(32) as extended1
146+
hash_numeric_extended(v, 0)::bit(32) as extended0,
147+
hash_numeric_extended(v, 1)::bit(32) as extended1
148148
FROM (VALUES (0), (1.149484958), (17.149484958), (42.149484958),
149149
(149484958.550273), (2071124898672)) x(v)
150150
WHERE hash_numeric(v)::bit(32) != hash_numeric_extended(v, 0)::bit(32)
@@ -154,8 +154,8 @@ WHERE hash_numeric(v)::bit(32) != hash_numeric_extended(v, 0)::bit(32)
154154
(0 rows)
155155

156156
SELECT v as value, hashmacaddr8(v)::bit(32) as standard,
157-
hashmacaddr8extended(v, 0)::bit(32) as extended0,
158-
hashmacaddr8extended(v, 1)::bit(32) as extended1
157+
hashmacaddr8extended(v, 0)::bit(32) as extended0,
158+
hashmacaddr8extended(v, 1)::bit(32) as extended1
159159
FROM (VALUES (NULL::macaddr8), ('08:00:2b:01:02:04:36:49'),
160160
('08:00:2b:01:02:04:f0:e8'), ('e2:7f:51:3e:70:49:16:29'),
161161
('d6:a9:4a:78:1c:d5:47:32'), ('ea:29:b1:5e:1f:a5')) x(v)
@@ -166,8 +166,8 @@ WHERE hashmacaddr8(v)::bit(32) != hashmacaddr8extended(v, 0)::bit(32)
166166
(0 rows)
167167

168168
SELECT v as value, hash_array(v)::bit(32) as standard,
169-
hash_array_extended(v, 0)::bit(32) as extended0,
170-
hash_array_extended(v, 1)::bit(32) as extended1
169+
hash_array_extended(v, 0)::bit(32) as extended0,
170+
hash_array_extended(v, 1)::bit(32) as extended1
171171
FROM (VALUES ('{0}'::int4[]), ('{0,1,2,3,4}'), ('{17,18,19,20}'),
172172
('{42,34,65,98}'), ('{550273,590027, 870273}'),
173173
('{207112489, 807112489}')) x(v)
@@ -178,19 +178,19 @@ WHERE hash_array(v)::bit(32) != hash_array_extended(v, 0)::bit(32)
178178
(0 rows)
179179

180180
SELECT v as value, hashbpchar(v)::bit(32) as standard,
181-
hashbpcharextended(v, 0)::bit(32) as extended0,
182-
hashbpcharextended(v, 1)::bit(32) as extended1
181+
hashbpcharextended(v, 0)::bit(32) as extended0,
182+
hashbpcharextended(v, 1)::bit(32) as extended1
183183
FROM (VALUES (NULL), ('PostgreSQL'), ('eIpUEtqmY89'), ('AXKEJBTK'),
184-
('muop28x03'), ('yi3nm0d73')) x(v)
184+
('muop28x03'), ('yi3nm0d73')) x(v)
185185
WHERE hashbpchar(v)::bit(32) != hashbpcharextended(v, 0)::bit(32)
186186
OR hashbpchar(v)::bit(32) = hashbpcharextended(v, 1)::bit(32);
187187
value | standard | extended0 | extended1
188188
-------+----------+-----------+-----------
189189
(0 rows)
190190

191191
SELECT v as value, time_hash(v)::bit(32) as standard,
192-
time_hash_extended(v, 0)::bit(32) as extended0,
193-
time_hash_extended(v, 1)::bit(32) as extended1
192+
time_hash_extended(v, 0)::bit(32) as extended0,
193+
time_hash_extended(v, 1)::bit(32) as extended1
194194
FROM (VALUES (NULL::time), ('11:09:59'), ('1:09:59'), ('11:59:59'),
195195
('7:9:59'), ('5:15:59')) x(v)
196196
WHERE time_hash(v)::bit(32) != time_hash_extended(v, 0)::bit(32)
@@ -200,35 +200,35 @@ WHERE time_hash(v)::bit(32) != time_hash_extended(v, 0)::bit(32)
200200
(0 rows)
201201

202202
SELECT v as value, timetz_hash(v)::bit(32) as standard,
203-
timetz_hash_extended(v, 0)::bit(32) as extended0,
204-
timetz_hash_extended(v, 1)::bit(32) as extended1
203+
timetz_hash_extended(v, 0)::bit(32) as extended0,
204+
timetz_hash_extended(v, 1)::bit(32) as extended1
205205
FROM (VALUES (NULL::timetz), ('00:11:52.518762-07'), ('00:11:52.51762-08'),
206-
('00:11:52.62-01'), ('00:11:52.62+01'), ('11:59:59+04')) x(v)
206+
('00:11:52.62-01'), ('00:11:52.62+01'), ('11:59:59+04')) x(v)
207207
WHERE timetz_hash(v)::bit(32) != timetz_hash_extended(v, 0)::bit(32)
208208
OR timetz_hash(v)::bit(32) = timetz_hash_extended(v, 1)::bit(32);
209209
value | standard | extended0 | extended1
210210
-------+----------+-----------+-----------
211211
(0 rows)
212212

213213
SELECT v as value, interval_hash(v)::bit(32) as standard,
214-
interval_hash_extended(v, 0)::bit(32) as extended0,
215-
interval_hash_extended(v, 1)::bit(32) as extended1
214+
interval_hash_extended(v, 0)::bit(32) as extended0,
215+
interval_hash_extended(v, 1)::bit(32) as extended1
216216
FROM (VALUES (NULL::interval),
217217
('5 month 7 day 46 minutes'), ('1 year 7 day 46 minutes'),
218-
('1 year 7 month 20 day 46 minutes'), ('5 month'),
219-
('17 year 11 month 7 day 9 hours 46 minutes 5 seconds')) x(v)
218+
('1 year 7 month 20 day 46 minutes'), ('5 month'),
219+
('17 year 11 month 7 day 9 hours 46 minutes 5 seconds')) x(v)
220220
WHERE interval_hash(v)::bit(32) != interval_hash_extended(v, 0)::bit(32)
221221
OR interval_hash(v)::bit(32) = interval_hash_extended(v, 1)::bit(32);
222222
value | standard | extended0 | extended1
223223
-------+----------+-----------+-----------
224224
(0 rows)
225225

226226
SELECT v as value, timestamp_hash(v)::bit(32) as standard,
227-
timestamp_hash_extended(v, 0)::bit(32) as extended0,
228-
timestamp_hash_extended(v, 1)::bit(32) as extended1
227+
timestamp_hash_extended(v, 0)::bit(32) as extended0,
228+
timestamp_hash_extended(v, 1)::bit(32) as extended1
229229
FROM (VALUES (NULL::timestamp), ('2017-08-22 00:09:59.518762'),
230230
('2015-08-20 00:11:52.51762-08'),
231-
('2017-05-22 00:11:52.62-01'),
231+
('2017-05-22 00:11:52.62-01'),
232232
('2013-08-22 00:11:52.62+01'), ('2013-08-22 11:59:59+04')) x(v)
233233
WHERE timestamp_hash(v)::bit(32) != timestamp_hash_extended(v, 0)::bit(32)
234234
OR timestamp_hash(v)::bit(32) = timestamp_hash_extended(v, 1)::bit(32);
@@ -237,12 +237,12 @@ WHERE timestamp_hash(v)::bit(32) != timestamp_hash_extended(v, 0)::bit(32)
237237
(0 rows)
238238

239239
SELECT v as value, uuid_hash(v)::bit(32) as standard,
240-
uuid_hash_extended(v, 0)::bit(32) as extended0,
241-
uuid_hash_extended(v, 1)::bit(32) as extended1
240+
uuid_hash_extended(v, 0)::bit(32) as extended0,
241+
uuid_hash_extended(v, 1)::bit(32) as extended1
242242
FROM (VALUES (NULL::uuid), ('a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11'),
243-
('5a9ba4ac-8d6f-11e7-bb31-be2e44b06b34'),
243+
('5a9ba4ac-8d6f-11e7-bb31-be2e44b06b34'),
244244
('99c6705c-d939-461c-a3c9-1690ad64ed7b'),
245-
('7deed3ca-8d6f-11e7-bb31-be2e44b06b34'),
245+
('7deed3ca-8d6f-11e7-bb31-be2e44b06b34'),
246246
('9ad46d4f-6f2a-4edd-aadb-745993928e1e')) x(v)
247247
WHERE uuid_hash(v)::bit(32) != uuid_hash_extended(v, 0)::bit(32)
248248
OR uuid_hash(v)::bit(32) = uuid_hash_extended(v, 1)::bit(32);
@@ -251,10 +251,10 @@ WHERE uuid_hash(v)::bit(32) != uuid_hash_extended(v, 0)::bit(32)
251251
(0 rows)
252252

253253
SELECT v as value, pg_lsn_hash(v)::bit(32) as standard,
254-
pg_lsn_hash_extended(v, 0)::bit(32) as extended0,
255-
pg_lsn_hash_extended(v, 1)::bit(32) as extended1
254+
pg_lsn_hash_extended(v, 0)::bit(32) as extended0,
255+
pg_lsn_hash_extended(v, 1)::bit(32) as extended1
256256
FROM (VALUES (NULL::pg_lsn), ('16/B374D84'), ('30/B374D84'),
257-
('255/B374D84'), ('25/B379D90'), ('900/F37FD90')) x(v)
257+
('255/B374D84'), ('25/B379D90'), ('900/F37FD90')) x(v)
258258
WHERE pg_lsn_hash(v)::bit(32) != pg_lsn_hash_extended(v, 0)::bit(32)
259259
OR pg_lsn_hash(v)::bit(32) = pg_lsn_hash_extended(v, 1)::bit(32);
260260
value | standard | extended0 | extended1
@@ -263,8 +263,8 @@ WHERE pg_lsn_hash(v)::bit(32) != pg_lsn_hash_extended(v, 0)::bit(32)
263263

264264
CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');
265265
SELECT v as value, hashenum(v)::bit(32) as standard,
266-
hashenumextended(v, 0)::bit(32) as extended0,
267-
hashenumextended(v, 1)::bit(32) as extended1
266+
hashenumextended(v, 0)::bit(32) as extended0,
267+
hashenumextended(v, 1)::bit(32) as extended1
268268
FROM (VALUES ('sad'::mood), ('ok'), ('happy')) x(v)
269269
WHERE hashenum(v)::bit(32) != hashenumextended(v, 0)::bit(32)
270270
OR hashenum(v)::bit(32) = hashenumextended(v, 1)::bit(32);
@@ -274,24 +274,24 @@ WHERE hashenum(v)::bit(32) != hashenumextended(v, 0)::bit(32)
274274

275275
DROP TYPE mood;
276276
SELECT v as value, jsonb_hash(v)::bit(32) as standard,
277-
jsonb_hash_extended(v, 0)::bit(32) as extended0,
278-
jsonb_hash_extended(v, 1)::bit(32) as extended1
277+
jsonb_hash_extended(v, 0)::bit(32) as extended0,
278+
jsonb_hash_extended(v, 1)::bit(32) as extended1
279279
FROM (VALUES (NULL::jsonb),
280-
('{"a": "aaa bbb ddd ccc", "b": ["eee fff ggg"], "c": {"d": "hhh iii"}}'),
281-
('{"foo": [true, "bar"], "tags": {"e": 1, "f": null}}'),
282-
('{"g": {"h": "value"}}')) x(v)
280+
('{"a": "aaa bbb ddd ccc", "b": ["eee fff ggg"], "c": {"d": "hhh iii"}}'),
281+
('{"foo": [true, "bar"], "tags": {"e": 1, "f": null}}'),
282+
('{"g": {"h": "value"}}')) x(v)
283283
WHERE jsonb_hash(v)::bit(32) != jsonb_hash_extended(v, 0)::bit(32)
284284
OR jsonb_hash(v)::bit(32) = jsonb_hash_extended(v, 1)::bit(32);
285285
value | standard | extended0 | extended1
286286
-------+----------+-----------+-----------
287287
(0 rows)
288288

289289
SELECT v as value, hash_range(v)::bit(32) as standard,
290-
hash_range_extended(v, 0)::bit(32) as extended0,
291-
hash_range_extended(v, 1)::bit(32) as extended1
290+
hash_range_extended(v, 0)::bit(32) as extended0,
291+
hash_range_extended(v, 1)::bit(32) as extended1
292292
FROM (VALUES (int4range(10, 20)), (int4range(23, 43)),
293-
(int4range(5675, 550273)),
294-
(int4range(550274, 1550274)), (int4range(1550275, 208112489))) x(v)
293+
(int4range(5675, 550273)),
294+
(int4range(550274, 1550274)), (int4range(1550275, 208112489))) x(v)
295295
WHERE hash_range(v)::bit(32) != hash_range_extended(v, 0)::bit(32)
296296
OR hash_range(v)::bit(32) = hash_range_extended(v, 1)::bit(32);
297297
value | standard | extended0 | extended1

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp