Re: argument of CASE/WHEN must not return a set

Поиск

Список

Период

Сортировка

От	Sameer Kumar
Тема	Re: argument of CASE/WHEN must not return a set
Дата	10 января 2014 г. 11:43:14
Msg-id	CADp-Sm61+ScXi48PJFtzwBFeuLWg-+nzXu_9OEK95t_WaBj7bw@mail.gmail.com обсуждение исходный текст
Ответ на	Re: argument of CASE/WHEN must not return a set ("George Weaver" <gweaver@shaw.ca>)
Список	pgsql-general

On Fri, Jan 10, 2014 at 12:02 AM, George Weaver <gweaver@shaw.ca> wrote:

Thanks David,

I found that if the whole expression is made a sub-select it works:

I too eventually got there. :-)

Check the plan for two queries that you have.

Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M : +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz