domain type and array, is it possible?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема domain type and array, is it possible?
Дата
Msg-id Pine.LNX.4.44.0405102019140.27891-100000@kix.fsv.cvut.cz
обсуждение исходный текст
Ответы Re: domain type and array, is it possible?  (Kris Jurka <books@ejurka.com>)
Список pgsql-general
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








В списке pgsql-general по дате отправления:

Предыдущее
От: "Sally Sally"
Дата:
Сообщение: Re: basic question (shared buffers vs. effective cache size)
Следующее
От: Frank Miles
Дата:
Сообщение: Re: nested elseif woes