Re: Fixing bug #8228 ("set-valued function called in context that cannot accept a set")

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fixing bug #8228 ("set-valued function called in context that cannot accept a set")
Date: 2014-01-07 02:52:53
Message-ID: 1389063173175-5785629.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane-2 wrote
> I kinda forgot about this bug when I went off on vacation:
> http://www.postgresql.org/message-id/

> E1UnCv4-0007oF-Bo(at)(dot)postgresql

Just to clarify:

This patch will cause both executions of the example query to fail with the
"set-valued function..." error.

Also, the reason the "::varchar" one did not fail was because not cast
function was ever called but the "::varchar(30)" forced a function call and
thus prompted the error when the second record and resultant regexp_matches
expression was encountered.

Thanks!

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Fixing-bug-8228-set-valued-function-called-in-context-that-cannot-accept-a-set-tp5785622p5785629.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2014-01-07 02:55:32 Re: [bug fix] multibyte messages are displayed incorrectly on the client
Previous Message Etsuro Fujita 2014-01-07 02:40:32 Re: Show lossy heap block info in EXPLAIN ANALYZE for bitmap heap scan