Home > mailing lists

Re: argument of CASE/WHEN must not return a set - Mailing list pgsql-general

From	Sameer Kumar
Subject	Re: argument of CASE/WHEN must not return a set
Date	January 10, 2014 11:43:14
Msg-id	CADp-Sm61+ScXi48PJFtzwBFeuLWg-+nzXu_9OEK95t_WaBj7bw@mail.gmail.com Whole thread Raw
In response to	Re: argument of CASE/WHEN must not return a set ("George Weaver" <gweaver@shaw.ca>)
List	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

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).

From: Chris Hiestand
Date: 10 January 2014, 09:36:58
Subject: Re: postgres.app OS X psql character encoding (utf-8) problem

From: "ygnhzeus"
Date: 10 January 2014, 12:00:42
Subject: How to specify/mock the statistic data of tables in PostgreSQL