Re: plpgsql return setof integer?

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Christopher Murtagh <christopher(dot)murtagh(at)mcgill(dot)ca>
Cc: postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: plpgsql return setof integer?
Date: 2005-08-24 21:43:07
Message-ID: 20050824214307.GI17609@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey Christopher,

On Wed, Nov 12, 2003 at 11:42:56PM -0500, Christopher Murtagh wrote:
> 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.

I didn't really expect to remember this two years later :-), but I
was going over my old mail in order to delete the trash that is usually
left behind. So if you still have that coffee around, there's news
that you'll be soon able to get rid of it: I'll be visiting McGill Uni
or thereabouts, for a Slony-II meeting. Maybe I can relieve you of it
then ;-)

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"La soledad es compañía"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Davis 2005-08-24 22:15:12 Re: Problem finding libpg.3.dylib on macos X in plperlu
Previous Message Welty, Richard 2005-08-24 21:28:06 Re: Postgresql replication