\u0030-\u0039]{1,3}$'.
The second mistake I made with the escaping of characters. In my case four "\"
are needed to write a regular expression with "\d". So '^d{1,3}$' works
correct.
Thanks to all who gives me new ideas to solve the problem and kind regards,
Ca
regards
Carsten Ungermann
Am 09.09.2010 um 15:44 schrieb Szymon Guz:
>
>
> On 9 September 2010 12:55, Ungermann Carsten
> wrote:
> Dear postgres list,
>
> I need to verify the value of a column by a regular expression in an
> if-statement before insert or update. It
Dear postgres list,
I need to verify the value of a column by a regular expression in an
if-statement before insert or update. It should be a one to three digit value.
I wrote a trigger and a trigger function. In the trigger function I want to use
the following if-statement to verify the value:
