Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group