domain type and array, is it possible?

[Pavel Stehule]

Hello

Can I use domain in array. I want to save "xml normalized string"
into array.

CREATE OR REPLACE FUNCTION normString(varchar) RETURNS bool AS '
SELECT $1 !~ ''[\r\t\n]'';
' LANGUAGE sql;

CREATE OR REPLACE FUNCTION chLength(varchar, integer, integer) RETURNS
bool AS '
SELECT length($1) BETWEEN $2 AND $3;
' LANGUAGE sql;

CREATE DOMAIN optPostalLineType AS varchar(255)
CHECK(normString(value) AND chLength(value, 255));

CREATE TABLE addresses (
id serial primary key,
tbl char(1) NOT NULL CHECK (tbl IN ('s')),
type postalInfoEnumType,
street optPostalLineType[3] NULL,
city postalLineType,
zip zipType,
country countryType NULL
)

but I get message ERROR: type "optpostallinetype[]" does not exist.
Is it possible combine DOMAIN and array?

Thank You
Pavel Stehule
p.s. I use CVS PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Kris Jurka]

On Mon, 10 May 2004, Pavel Stehule wrote:

Hello

Can I use domain in array. I want to save "xml normalized string"
into array.

No, you can't have arrays of domains. See this recent -hackers message
for why.

http://archives.postgresql.org/pgsql...4/msg00568.php

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)