Search Postgresql Archives

domain type and array, is it possible?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux