missing support for using regex and arrays

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: missing support for using regex and arrays
Date: 2004-05-11 07:35:46
Message-ID: Pine.LNX.4.44.0405110931140.523-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-05-11 09:00:55 BUG #1149: server includes not installed by default
Previous Message Tom Lane 2004-05-10 23:31:08 Re: insert/upate/delete permissions on views