missing support for using regex and arrays - Mailing list pgsql-bugs

From Pavel Stehule
Subject missing support for using regex and arrays
Date
Msg-id Pine.LNX.4.44.0405110931140.523-100000@kix.fsv.cvut.cz
Whole thread Raw
Responses Re: missing support for using regex and arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hello

I need to solve checking varchar array. I can write

CHECK('aaa' = ALL(x)) -- x is array
but I can't CHECK(ALL(x) = 'aaaa') or CHECK (ALL(x) ~ 'regex')

I know so I can write plpgsql function. I have question for hackers. Do
You plan better support for it?

Thank You
Pavel Stehule

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: insert/upate/delete permissions on views
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1149: server includes not installed by default