Re: plpgsql return setof integer?

From: Christopher Murtagh <christopher(dot)murtagh(at)mcgill(dot)ca>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: plpgsql return setof integer?
Date: 2003-11-13 04:42:56
Message-ID: 1068698575.3924.23.camel@mafalda.murtagh.name
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2003-11-12 at 22:57, Alvaro Herrera wrote:
> You are initializing the array incorrectly in your htdig(text, text)
> function. {} is the hash reference you are seeing; HASH(0xwhatever) is
> its text representation. Do
>
> my @Result = ();
>
> instead, or leave it uninitialized.

Thanks once again. You've really helped a lot on this. I especially
liked your 'return qq/{"/ . (join qq/","/, @_) . qq/"}/;' code. If you
were in Montreal, I would owe you a dinner or at least a coffee and a
big thanks. If you ever come this way, please be sure to give me a call.
Thanks again!

Cheers,

Chris

--
Christopher Murtagh
Enterprise Systems Administrator
ISR / Web Communications Group
McGill University
Montreal, Quebec
Canada

Tel.: (514) 398-3122
Fax: (514) 398-2017

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-11-13 04:43:17 Re: embedded postgresql
Previous Message Bruce Momjian 2003-11-13 04:36:16 Re: [HACKERS] Proposal for a cascaded master-slave replication system