Thread: domain type and array, is it possible?

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

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-hackers/2004-04/msg00568.php

Kris Jurka