From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: What do I do with this error? |
Date: | 2001-03-19 04:21:30 |
Message-ID: | Pine.BSF.4.21.0103182019170.23523-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Using the below (with a few fixes, delcare->declare
and adding the close quote and language type as plpgsql,
and a table1 defined as id int, field1 varchar, field2 varchar,
I get a NULL returned if I select test1(); I'm somewhere
between beta4 and 5 though.
On Sun, 18 Mar 2001, Josh Berkus wrote:
> Tom,
>
> > Yes, I'd say so. 7.1 returns a NULL as expected ...
>
> Er, Tom, I'm using 7.1.
>
> Pgsql does return a null as expected when going from the command line.
> However, if I call the regular expression from within a PL/pgSQL
> function, it bombs.
>
> Therefore, please forward to pgsql-bugs:
>
> Bug Name: Regular Expressions with NULL error out in PL/pgSQL.
> Can Reproduce: Reliably
> Severity: Annoyance.
> Location: PL/pgSQL / Function handler / SPI
> Version: 7.1 beta 3
>
> Description: If you attempt to run a query within a PL/pgSQL function
> which compares a field. via regular expression, to a NULL variable, you
> get a fatal error.
>
> Example:
>
> CREATE FUNCTION test1 () RETURNS INT4 AS
> 'DELCARE
> expression1 VARCHAR;
> return_value INT4;
> BEGIN
> expression1 := NULL;
> SELECT id INTO return_value
> FROM table1
> WHERE field2 ~* expression1;
> RETURN return_value;
> END;
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-03-19 04:22:21 | Re: What do I do with this error? |
Previous Message | Josh Berkus | 2001-03-19 04:09:59 | Re: What do I do with this error? |