Home > mailing lists

Re: COALESCE woes - Mailing list pgsql-general

From	Vick Khera
Subject	Re: COALESCE woes
Date	April 24, 2015 16:19:04
Msg-id	CALd+dceu4CpL0TPqLWjocJ9G6L1DCdF37nBLc7=zBSLYKu0Jsw@mail.gmail.com Whole thread Raw
In response to	COALESCE woes (Greg Spiegelberg <gspiegelberg@gmail.com>)
List	pgsql-general

On Fri, Apr 24, 2015 at 9:06 AM, Greg Spiegelberg <gspiegelberg@gmail.com> wrote:

LINE 3: SELECT COALESCE(ts1.user_id, ts2,user_id, ts3.user_id) AS us...

You want ts2.user_id not ts2,user_id

From: Andomar
Date: 24 April 2015, 16:18:36
Subject: Re: COALESCE woes

From: Marc-André Goderre
Date: 24 April 2015, 17:15:28
Subject: Re: Invalid memory alloc