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

Commite182959

Browse files
committed
Trim trailing whitespace --- needed commit to update anoncvs.
1 parent0bd4da2 commite182959

File tree

1 file changed

+26
-26
lines changed

1 file changed

+26
-26
lines changed

‎doc/src/sgml/intarray.sgml‎

Lines changed: 26 additions & 26 deletions
Original file line numberDiff line numberDiff line change
@@ -27,8 +27,8 @@
2727
<literal>int icount(int[])</literal> - the number of elements in intarray
2828
</para>
2929
<programlisting>
30-
test=# select icount('{1,2,3}'::int[]);
31-
icount
30+
test=# select icount('{1,2,3}'::int[]);
31+
icount
3232
--------
3333
3
3434
(1 row)
@@ -41,7 +41,7 @@ test=# select icount('{1,2,3}'::int[]);
4141
</para>
4242
<programlisting>
4343
test=# select sort('{1,2,3}'::int[],'desc');
44-
sort
44+
sort
4545
---------
4646
{3,2,1}
4747
(1 row)
@@ -56,7 +56,7 @@ test=# select sort('{1,2,3}'::int[],'desc');
5656

5757
<listitem>
5858
<para>
59-
<literal>int[] sort_asc(int[]),sort_desc(int[])</literal> - shortcuts for sort
59+
<literal>int[] sort_asc(int[]),sort_desc(int[])</literal> - shortcuts for sort
6060
</para>
6161
</listitem>
6262

@@ -66,7 +66,7 @@ test=# select sort('{1,2,3}'::int[],'desc');
6666
</para>
6767
<programlisting>
6868
test=# select uniq(sort('{1,2,3,2,1}'::int[]));
69-
uniq
69+
uniq
7070
---------
7171
{1,2,3}
7272
(1 row)
@@ -75,12 +75,12 @@ test=# select uniq(sort('{1,2,3,2,1}'::int[]));
7575

7676
<listitem>
7777
<para>
78-
<literal>int idx(int[], int item)</literal> - returns index of first
78+
<literal>int idx(int[], int item)</literal> - returns index of first
7979
intarray matching element to item, or '0' if matching failed.
8080
</para>
8181
<programlisting>
8282
test=# select idx('{1,2,3,2,1}'::int[],2);
83-
idx
83+
idx
8484
-----
8585
2
8686
(1 row)
@@ -89,12 +89,12 @@ test=# select idx('{1,2,3,2,1}'::int[],2);
8989

9090
<listitem>
9191
<para>
92-
<literal>int[] subarray(int[],int START [, int LEN])</literal> - returns
93-
part of intarray starting from element number START (from 1) and length LEN.
92+
<literal>int[] subarray(int[],int START [, int LEN])</literal> - returns
93+
part of intarray starting from element number START (from 1) and length LEN.
9494
</para>
9595
<programlisting>
9696
test=# select subarray('{1,2,3,2,1}'::int[],2,3);
97-
subarray
97+
subarray
9898
----------
9999
{2,3,2}
100100
(1 row)
@@ -107,7 +107,7 @@ test=# select subarray('{1,2,3,2,1}'::int[],2,3);
107107
</para>
108108
<programlisting>
109109
test=# select intset(1);
110-
intset
110+
intset
111111
--------
112112
{1}
113113
(1 row)
@@ -178,8 +178,8 @@ test=# select intset(1);
178178
<row>
179179
<entry><literal>int[] @@ query_int</literal></entry>
180180
<entry>
181-
returns TRUE if array satisfies query (like
182-
<literal>'1&amp;(2|3)'</literal>)
181+
returns TRUE if array satisfies query (like
182+
<literal>'1&amp;(2|3)'</literal>)
183183
</entry>
184184
</row>
185185

@@ -212,7 +212,7 @@ CREATE unique index message_section_map_key2 ON message_section_map (sid, mid );
212212
CREATE INDEX message_rdtree_idx ON message USING GIST ( sections gist__int_ops);
213213

214214
-- select some messages with section in 1 OR 2 - OVERLAP operator
215-
SELECT message.mid FROM message WHERE message.sections && '{1,2}';
215+
SELECT message.mid FROM message WHERE message.sections && '{1,2}';
216216

217217
-- select messages contains in sections 1 AND 2 - CONTAINS operator
218218
SELECT message.mid FROM message WHERE message.sections @> '{1,2}';
@@ -232,29 +232,29 @@ SELECT message.mid FROM message WHERE '{1,2}' <@ message.sections;
232232
2. psql TEST < ../_int.sql
233233
3. ./create_test.pl | psql TEST
234234
4. ./bench.pl - perl script to benchmark queries, supports OR, AND queries
235-
with/without RD-Tree. Run script without arguments to
235+
with/without RD-Tree. Run script without arguments to
236236
see availbale options.
237237

238238
a)test without RD-Tree (OR)
239239
./bench.pl -d TEST -c -s 1,2 -v
240-
b)test with RD-Tree
240+
b)test with RD-Tree
241241
./bench.pl -d TEST -c -s 1,2 -v -r
242242

243243
BENCHMARKS:
244-
244+
245245
Size of table &lt;message>: 200000
246-
Size of table &lt;message_section_map>: 269133
247-
246+
Size of table &lt;message_section_map>: 269133
247+
248248
Distribution of messages by sections:
249-
249+
250250
section 0: 74377 messages
251251
section 1: 16284 messages
252252
section 50: 1229 messages
253253
section 99: 683 messages
254-
254+
255255
old - without RD-Tree support,
256256
new - with RD-Tree
257-
257+
258258
+----------+---------------+----------------+
259259
|Search set|OR, time in sec|AND, time in sec|
260260
| +-------+-------+--------+-------+
@@ -274,10 +274,10 @@ SELECT message.mid FROM message WHERE '{1,2}' <@ message.sections;
274274
<sect2>
275275
<title>Authors</title>
276276
<para>
277-
All work was done by Teodor Sigaev (<email>teodor@stack.net</email>) and Oleg
278-
Bartunov (<email>oleg@sai.msu.su</email>). See
279-
<ulink url="http://www.sai.msu.su/~megera/postgres/gist"></ulink> for
280-
additional information. Andrey Oktyabrski did a great work on adding new
277+
All work was done by Teodor Sigaev (<email>teodor@stack.net</email>) and Oleg
278+
Bartunov (<email>oleg@sai.msu.su</email>). See
279+
<ulink url="http://www.sai.msu.su/~megera/postgres/gist"></ulink> for
280+
additional information. Andrey Oktyabrski did a great work on adding new
281281
functions and operations.
282282
</para>
283283
</sect2>

0 commit comments

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