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: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

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

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-2018 The PostgreSQL Global Development Group