Hello Bob,
On Sat, 2018-04-14 at 15:44 +0100, Bob Jones wrote:
> Hello,
>
>
>
> P.S. As a side-question, if anyone here has experience in using
> Postgres as a backend to PHP, are refcursors the way to go or should
> I
> be thinking of SETOF or other return styles ?
>
If you have a business
On 04/14/2018 09:36 AM, Bob Jones wrote:
On 14 April 2018 at 16:38, Tom Lane wrote:
Bob Jones writes:
My apologies if I'm being incredibly stupid here, but I've reviewed
what the docs have to say about naming portals and I still can't see
where I'm going wrong here ?
I think you're forgetti
On 14 April 2018 at 16:38, Tom Lane wrote:
> Bob Jones writes:
>> My apologies if I'm being incredibly stupid here, but I've reviewed
>> what the docs have to say about naming portals and I still can't see
>> where I'm going wrong here ?
>
> I think you're forgetting to double-quote an upper case
Bob Jones writes:
> My apologies if I'm being incredibly stupid here, but I've reviewed
> what the docs have to say about naming portals and I still can't see
> where I'm going wrong here ?
I think you're forgetting to double-quote an upper case identifier.
> FETCH ALL IN B;
> ERROR: cursor "b"
Hello,
My apologies if I'm being incredibly stupid here, but I've reviewed
what the docs have to say about naming portals and I still can't see
where I'm going wrong here ?
CREATE FUNCTION blah(v_id text,v_cursor refcursor) RETURNS refcursor
AS
$BODY$
BEGIN
OPEN v_cursor FOR SELECT * FROM blah w
