Re: COALESCE woes

From: Vick Khera <vivek(at)khera(dot)org>
To: Greg Spiegelberg <gspiegelberg(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: COALESCE woes
Date: 2015-04-24 13:18:54
Message-ID: CALd+dceu4CpL0TPqLWjocJ9G6L1DCdF37nBLc7=zBSLYKu0Jsw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 24, 2015 at 9:06 AM, Greg Spiegelberg <gspiegelberg(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2015-04-24 13:23:17 Re: Fwd: [GENERAL] 4B row limit for CLOB tables
Previous Message Andomar 2015-04-24 13:18:30 Re: COALESCE woes