Re: FETCH a cursor inside a SELECT

Поиск
Список
Период
Сортировка
От David Crawshaw
Тема Re: FETCH a cursor inside a SELECT
Дата
Msg-id 200211292351.21162.david@zentus.com
обсуждение исходный текст
Ответ на Re: FETCH a cursor inside a SELECT  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Ответы Re: FETCH a cursor inside a SELECT  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список pgsql-general
On Fri, 29 Nov 2002 11:42 pm, Shridhar Daithankar wrote:
> How about defining two views? One view that returns matchclass1 and
> another selects on this view to eliminate duplicates.

That would be a nice clean solution, but the functions are a search
system. The integer being passed into the functions is a comparing id
from another table, and then values are compared. As far as I know, a
view is just a static definition.

Reading the archives, I see 7.3 has just come out. Is it considered a
production environment solution? There aren't any references on the
website yet to anything other than 7.2.3.

If so, I could rewrite these functions with SETOF and RETURN NEXT...

David

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

Предыдущее
От: Jim Worke
Дата:
Сообщение: Re: Bad timestamp external representation
Следующее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: FETCH a cursor inside a SELECT