http://sqle.ru/index.php?action=history&feed=atom&title=PostgreSQL%2FArray%2FArray_Slice 2026-04-06T23:33:54Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=PostgreSQL/Array/Array_Slice&diff=4994&oldid=prev 2010-05-26T13:45:56Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://sqle.ru/index.php?title=PostgreSQL/Array/Array_Slice&diff=4995&oldid=prev 2010-05-26T10:14:34Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==An array slice is denoted by writing lower-bound:upper-bound for one or more array dimensions==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> postgres=#<br /> postgres=#<br /> postgres=# CREATE TABLE sal_emp (<br /> postgres(# name text,<br /> postgres(# pay_by_quarter integer[],<br /> postgres(# schedule text[][]<br /> postgres(# );<br /> CREATE TABLE<br /> postgres=#<br /> postgres=# INSERT INTO sal_emp<br /> postgres-# VALUES (&quot;Bill&quot;,<br /> postgres(# ARRAY[10000, 10000, 10000, 10000],<br /> postgres(# ARRAY[[&quot;meeting&quot;, &quot;lunch&quot;], [&quot;training&quot;, &quot;presentation&quot;]]);<br /> INSERT 0 1<br /> postgres=#<br /> postgres=# INSERT INTO sal_emp<br /> postgres-# VALUES (&quot;Carol&quot;,<br /> postgres(# ARRAY[20000, 25000, 25000, 25000],<br /> postgres(# ARRAY[[&quot;breakfast&quot;, &quot;consulting&quot;], [&quot;meeting&quot;, &quot;lunch&quot;]]);<br /> INSERT 0 1<br /> postgres=#<br /> postgres=# -- An array slice is denoted by writing lower-bound:upper-bound for one or more array dimensions.<br /> postgres=#<br /> postgres=# SELECT schedule[1:2][1:1] FROM sal_emp WHERE name = &quot;Bill&quot;;<br /> schedule<br /> ------------------------<br /> {{meeting},{training}}<br /> (1 row)<br /> postgres=#<br /> postgres=#<br /> postgres=# SELECT * FROM sal_emp;<br /> name | pay_by_quarter | schedule<br /> -------+---------------------------+-------------------------------------------<br /> Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}}<br /> Carol | {20000,25000,25000,25000} | {{breakfast,consulting},{meeting,lunch}}<br /> (2 rows)<br /> postgres=#<br /> postgres=#<br /> postgres=# drop table sal_emp;<br /> DROP TABLE<br /> postgres=#<br /> postgres=#<br /> postgres=#<br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==Selecting array values with slices==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> postgres=#<br /> postgres=# CREATE TABLE book (id integer,titles text[]);<br /> CREATE TABLE<br /> postgres=#<br /> postgres=# INSERT INTO book VALUES (102, &quot;{&quot;AAA\&quot;s VVVV&quot;}&quot;);<br /> INSERT 0 1<br /> postgres=# INSERT INTO book VALUES (103, &quot;{&quot;AAA&quot;, &quot;VVVV&quot;}&quot;);<br /> INSERT 0 1<br /> postgres=#<br /> postgres=#<br /> postgres=# -- Selecting array values with slices<br /> postgres=#<br /> postgres=# SELECT titles[1:2] FROM book;<br /> titles<br /> ----------------<br /> {&quot;AAA&quot;s VVVV&quot;}<br /> {AAA,VVVV}<br /> (2 rows)<br /> postgres=#<br /> postgres=# drop table book;<br /> DROP TABLE<br /> postgres=#<br /> <br /> &lt;/source&gt;</div>

Admin