Re: plpgsql return setof integer?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: plpgsql return setof integer?
Дата
Msg-id 20031113035727.GB1232@dcc.uchile.cl
обсуждение исходный текст
Ответ на plpgsql return setof integer?  (Christopher Murtagh <christopher.murtagh@mcgill.ca>)
Ответы Re: plpgsql return setof integer?  (Christopher Murtagh <christopher.murtagh@mcgill.ca>)
Список pgsql-general
On Wed, Nov 12, 2003 at 05:35:40PM -0500, Christopher Murtagh wrote:

> 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. :-)

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.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Un poeta es un mundo encerrado en un hombre" (Victor Hugo)

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Curious about exclusive table locks
Следующее
От: Lamar Owen
Дата:
Сообщение: Re: RHEL