http://www.sqle.ru/index.php?action=history&feed=atom&title=PostgreSQL%2FTable%2FComposite_Column
PostgreSQL/Table/Composite Column - История изменений
2026-05-24T11:43:17Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=PostgreSQL/Table/Composite_Column&diff=4634&oldid=prev
в 13:45, 26 мая 2010
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://www.sqle.ru/index.php?title=PostgreSQL/Table/Composite_Column&diff=4635&oldid=prev
Admin: 1 версия
2010-05-26T10:14:02Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Insert value to composite column==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
postgres=#<br />
postgres=# CREATE TYPE inventory_item AS (<br />
postgres(# name text,<br />
postgres(# supplier_id integer,<br />
postgres(# price numeric<br />
postgres(# );<br />
CREATE TYPE<br />
postgres=#<br />
postgres=# CREATE TABLE on_hand (<br />
postgres(# item inventory_item,<br />
postgres(# count integer<br />
postgres(# );<br />
CREATE TABLE<br />
postgres=#<br />
postgres=# INSERT INTO on_hand VALUES (ROW("fuzzy dice", 42, 1.99), 1000);<br />
INSERT 0 1<br />
postgres=#<br />
postgres=# select * from on_hand;<br />
item | count<br />
------------------------+-------<br />
("fuzzy dice",42,1.99) | 1000<br />
(1 row)<br />
postgres=#<br />
postgres=# SELECT (item).name FROM on_hand WHERE (item).price > 0.99;<br />
name<br />
------------<br />
fuzzy dice<br />
(1 row)<br />
postgres=#<br />
postgres=# drop table on_hand;<br />
DROP TABLE<br />
postgres=# drop type inventory_item;<br />
DROP TYPE<br />
postgres=#<br />
postgres=#<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Reference column name through table name==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
postgres=#<br />
postgres=# CREATE TYPE inventory_item AS (<br />
postgres(# name text,<br />
postgres(# supplier_id integer,<br />
postgres(# price numeric<br />
postgres(# );<br />
CREATE TYPE<br />
postgres=#<br />
postgres=# CREATE TABLE on_hand (<br />
postgres(# item inventory_item,<br />
postgres(# count integer<br />
postgres(# );<br />
CREATE TABLE<br />
postgres=#<br />
postgres=# INSERT INTO on_hand VALUES (ROW("fuzzy dice", 42, 1.99), 1000);<br />
INSERT 0 1<br />
postgres=#<br />
postgres=# select * from on_hand;<br />
item | count<br />
------------------------+-------<br />
("fuzzy dice",42,1.99) | 1000<br />
(1 row)<br />
postgres=#<br />
postgres=# SELECT (on_hand.item).name FROM on_hand WHERE (on_hand.item).price > 0.99;<br />
name<br />
------------<br />
fuzzy dice<br />
(1 row)<br />
postgres=#<br />
postgres=# drop table on_hand;<br />
DROP TABLE<br />
postgres=# drop type inventory_item;<br />
DROP TYPE<br />
postgres=#<br />
postgres=#<br />
postgres=#<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==To access a field of a composite column==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
postgres=#<br />
postgres=# CREATE TYPE inventory_item AS (<br />
postgres(# name text,<br />
postgres(# supplier_id integer,<br />
postgres(# price numeric<br />
postgres(# );<br />
CREATE TYPE<br />
postgres=#<br />
postgres=# CREATE TABLE on_hand (<br />
postgres(# item inventory_item,<br />
postgres(# count integer<br />
postgres(# );<br />
CREATE TABLE<br />
postgres=#<br />
postgres=# INSERT INTO on_hand VALUES (ROW("fuzzy dice", 42, 1.99), 1000);<br />
INSERT 0 1<br />
postgres=#<br />
postgres=# select * from on_hand;<br />
item | count<br />
------------------------+-------<br />
("fuzzy dice",42,1.99) | 1000<br />
(1 row)<br />
postgres=#<br />
postgres=#<br />
postgres=# -- To access a field of a composite column<br />
postgres=#<br />
postgres=#<br />
postgres=# SELECT (item).name FROM on_hand WHERE (item).price > 9.99;<br />
name<br />
------<br />
(0 rows)<br />
postgres=#<br />
postgres=# drop table on_hand;<br />
DROP TABLE<br />
postgres=# drop type inventory_item;<br />
DROP TYPE<br />
postgres=#<br />
postgres=#<br />
<br />
</source></div>
Admin