Re: FETCH a cursor inside a SELECT

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: FETCH a cursor inside a SELECT
Дата
Msg-id 3DE7BC22.20902.6651785@localhost
обсуждение исходный текст
Ответ на FETCH a cursor inside a SELECT  (David Crawshaw <david@zentus.com>)
Ответы Re: FETCH a cursor inside a SELECT  (David Crawshaw <david@zentus.com>)
Список pgsql-general
On 29 Nov 2002 at 23:33, David Crawshaw wrote:

> I've been working with this all day, and I'm finally out of ideas.
> Hopefully someone has encountered a situation like this before.
>
> Originally I was going to write a function that returned a series of
> id's, but this caused no end of confusion on PG 7.2.3. Instead, I've
> decided to return cursors.
>
> matchClass1 works as expected. However in matchClass2, I wish to exclude
> all of the results from matchClass1. This inline fetch gives me the
> following error calling matchClass2:

How about defining two views? One view that returns matchclass1 and another
selects on this view to eliminate duplicates.

i.e. using views as functions/cursors returning multiple recordset..

Just a thought.. Did not follow earlier thread so might be next to useless as
well..

Bye
 Shridhar

--
"We'll look into it":    By the time the wheels make a full turn, we    assume you
will have forgotten about it, too.


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

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