From: | Christopher Murtagh <christopher(dot)murtagh(at)mcgill(dot)ca> |
---|---|
To: | postgres general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: plpgsql return setof integer? |
Date: | 2003-11-12 23:23:12 |
Message-ID: | 1068679392.2960.1.camel@mafalda.murtagh.name |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 2003-11-12 at 17:35, Christopher Murtagh wrote:
> I've got a fairly simple function that I'm trying to return a set, but
> seem to have come across a stumbling block. When I execute the function
> below (the input params are not used at the moment) I get this:
>
> chris=# select htdig('foo', 'foo');
Actually, I just found my problem. I changed the above query to:
chris=# select * from htdig('foo', 'foo');
and it works as expected. Thanks again to everyone on this list who
helped out.
Cheers,
Chris
--
Christopher Murtagh
Enterprise Systems Administrator
ISR / Web Communications Group
McGill University
Montreal, Quebec
Canada
Tel.: (514) 398-3122
Fax: (514) 398-2017
From | Date | Subject | |
---|---|---|---|
Next Message | Alex | 2003-11-12 23:44:42 | PL/PGSQL functions suddenly not working |
Previous Message | Tom Lane | 2003-11-12 23:01:14 | Re: how can I change a btree index into a hash index? |