plpgsql return setof integer?

Поиск
Список
Период
Сортировка
От Christopher Murtagh
Тема plpgsql return setof integer?
Дата
Msg-id 1068676539.2824.10.camel@mafalda.murtagh.name
обсуждение исходный текст
Ответы Re: plpgsql return setof integer?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-general
Greetings,

 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');
ERROR:  set-valued function called in context that cannot accept a set
CONTEXT:  PL/pgSQL function "htdig" line 14 at return next


CREATE OR REPLACE FUNCTION htdig(text, text) RETURNS SETOF integer AS '
DECLARE
  result text[];
  low integer;
  high integer;
  item integer;
BEGIN
    result := htsearch(''sample_return.txt'',''dbname'');
    low  := 2;
    high := array_upper(result, 1);

    FOR i IN low..high LOOP
      item := result[i];
      RETURN NEXT item;
    END LOOP;
  RETURN;
END;
' LANGUAGE 'plpgsql' STABLE STRICT;


The function htsearch is working as expected (other than a strange HASH
as the first element, but I've compensated for that by starting at array
index 2). This is what it outputs:

chris=# select htsearch('sample_return2.txt','dbname');
             htsearch
----------------------------------
 {HASH(0x835c298),2100,2113,2114}
(1 row)

Any obvious thing that I'm doing wrong? I'm using 7.4RC2. As always, any
help or info would be much appreciated. Bonus points if someone knows
what the HASH is. :-)

Cheers,

Chris

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

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how can I change a btree index into a hash index?
Следующее
От: Greg Stark
Дата:
Сообщение: Re: SQL-question: returning the id of an insert querry