Re: Example code Re: Singleton SELECT inside cursor loop

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Example code Re: Singleton SELECT inside cursor loop
Дата
Msg-id f8f50eb5-28d2-25d9-aa0a-eed150f17aad@gmail.com
обсуждение исходный текст
Ответ на Re: Example code Re: Singleton SELECT inside cursor loop  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Список pgsql-general
Дерево обсуждения 
On 10/1/22 07:20, Peter J. Holzer wrote:
> On 2022-10-01 02:22:22 -0500, Ron wrote:
>> I extracted the singleton into a function, and that helped me isolate the
>> problem.
> I don't know what a singleton select is (duckduckgo tells me it has
> something to do with DB2 and/or COBOL, or maybe it's a whisky), but:

A query which returns one row.  Typically SELECT COUNT/MAX/etc without a 
GROUP BY clause.

-- 
Angular momentum makes the world go 'round.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Names of run-time configuration parameters (was: Limiting the operations that client-side code can perform upon its database backend's artifacts)
Следующее
От: Ron
Дата:
Сообщение: Re: Example code Re: Singleton SELECT inside cursor loop