Re: Function is called multiple times in subselect

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Function is called multiple times in subselect
Дата
Msg-id
4690.1079064141@sss.pgh.pa.us
Ответ на
Function is called multiple times in subselect (Chris Campbell)
Список
Дерево обсуждения
Function is called multiple times in subselect Chris Campbell <chris@bignerdranch.com>
Re: Function is called multiple times in subselect Tom Lane <tgl@sss.pgh.pa.us>
Re: Function is called multiple times in subselect "Alex J. Avriette" <alex@posixnap.net>
Re: Function is called multiple times in subselect Chris Campbell <chris@bignerdranch.com>
Re: Function is called multiple times in subselect Tom Lane <tgl@sss.pgh.pa.us>
Re: Function is called multiple times in subselect Tom Lane <tgl@sss.pgh.pa.us>
Re: Function is called multiple times in subselect "Alex J. Avriette" <alex@posixnap.net> 
Chris Campbell  writes:
> I don't think this should be happening (PostgreSQL 7.4.1).

Sorry, this isn't a bug.  Flattening the subquery is generally desirable
behavior.

I think the easiest way to force the subquery not to be flattened is to
insert a LIMIT or OFFSET clause, viz

	SELECT ... FROM (SELECT ... OFFSET 0) query;

			regards, tom lane
В списке pgsql-bugs по дате отправления
Предыдущее
От: Chris Campbell
Дата:
Следующее
От: Bruce Momjian
Дата:
FAQ