<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[Forum PostgreSQL - problem z array'em w composite type]]></title>
	<link rel="self" href="http://forum.postgresql.org.pl/extern.php?action=feed&amp;tid=68&amp;type=atom"/>
	<updated>2008-08-12T14:52:22Z</updated>
	<generator>PunBB</generator>
	<id>https://forum.postgresql.org.pl/viewtopic.php?id=68</id>
		<entry>
			<title type="html"><![CDATA[Odp: problem z array'em w composite type]]></title>
			<link rel="alternate" href="https://forum.postgresql.org.pl/viewtopic.php?pid=235#p235"/>
			<content type="html"><![CDATA[cytat z dokumentacji (postgresql.org)
8.2.9 (i wcześniejszy)
"PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in or user-defined base type can be created. (Arrays of composite types or domains are not yet supported, however.)"
8.3.3 (i inne z gałęzi 8.3)
"PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in or user-defined base type, enum type, or composite type can be created. Arrays of domains are not yet supported."]]></content>
			<author>
				<name><![CDATA[rski]]></name>
				<uri>https://forum.postgresql.org.pl/profile.php?id=26</uri>
			</author>
			<updated>2008-08-12T14:52:22Z</updated>
			<id>https://forum.postgresql.org.pl/viewtopic.php?pid=235#p235</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Odp: problem z array'em w composite type]]></title>
			<link rel="alternate" href="https://forum.postgresql.org.pl/viewtopic.php?pid=233#p233"/>
			<content type="html"><![CDATA[PostgreSQL 8.2.1

ja gdzies przeczytalem ze od 8.x

dobra zobacze w 8.3 

dzieki]]></content>
			<author>
				<name><![CDATA[sebson]]></name>
				<uri>https://forum.postgresql.org.pl/profile.php?id=207</uri>
			</author>
			<updated>2008-08-12T13:19:04Z</updated>
			<id>https://forum.postgresql.org.pl/viewtopic.php?pid=233#p233</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Odp: problem z array'em w composite type]]></title>
			<link rel="alternate" href="https://forum.postgresql.org.pl/viewtopic.php?pid=232#p232"/>
			<content type="html"><![CDATA[Jaki postgres?, bo z tego co pamietam to tabele typow zlozonych sa wspierane dopiero od 8.3]]></content>
			<author>
				<name><![CDATA[rski]]></name>
				<uri>https://forum.postgresql.org.pl/profile.php?id=26</uri>
			</author>
			<updated>2008-08-12T12:20:10Z</updated>
			<id>https://forum.postgresql.org.pl/viewtopic.php?pid=232#p232</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[problem z array'em w composite type]]></title>
			<link rel="alternate" href="https://forum.postgresql.org.pl/viewtopic.php?pid=230#p230"/>
			<content type="html"><![CDATA[Witam,

Mam nastepujacy problem:


mam typ: t_01
[code]CREATE TYPE t_01 AS (
   id BIGINT,
   name VARCHAR,
   value VARCHAR
);[/code]
chce teraz stowrzyc typ t_02 ktory bedzie zawieral w sobie t_01

[code]CREATE TYPE t_02 AS (
   id BIGINT,
   name VARCHAR,
   content t_01[]
);[/code]
niestety odpowiedz brzmi

ERROR:  type "public.t_01[]" does not exist]]></content>
			<author>
				<name><![CDATA[sebson]]></name>
				<uri>https://forum.postgresql.org.pl/profile.php?id=207</uri>
			</author>
			<updated>2008-08-12T09:29:00Z</updated>
			<id>https://forum.postgresql.org.pl/viewtopic.php?pid=230#p230</id>
		</entry>
</feed>
