Date: Fri, 17 Feb 2017 10:56:01 -0700 (MST)
From: sqlQuestions <ryanpgodfrey@gmail.com>
To: pgsql-sql@postgresql.org
Message-ID: <1487354161516-5944935.post@n3.nabble.com>
In-Reply-To: 
 <CAKFQuwZx7x7DijFfGzp26zW8PDnv9wrEz2JsS232yyB+VPZmvg@mail.gmail.com>
References: <1487283597419-5944796.post@n3.nabble.com>
 <CAKFQuwYpF146ygOUSXSsAxdAKGsSUXt=a5HtRpUQT=YTy+mwkw@mail.gmail.com>
 <1487286348488-5944801.post@n3.nabble.com>
 <CAKFQuwbdNiN=-ij7Lz0gc6XRwe2cPoVKyc+WH-Z_9+7FR=yj5g@mail.gmail.com>
 <1487345617421-5944908.post@n3.nabble.com>
 <CAKFQuwZx7x7DijFfGzp26zW8PDnv9wrEz2JsS232yyB+VPZmvg@mail.gmail.com>
Subject: Re: Conditional Lookup Table with Like
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

That's pretty cool, I didn't know that one. But I still want to return the
result from table1 when there is null category.

This returns 4 correct results but needs to return the two product_code 3s
with null category:

SELECT table1.product_code, table1.date_signed, table1.description,
COALESCE ((
    SELECT table3.category
    FROM table3
    WHERE table3.psc_code = table1.product_code
    AND lower(table1.description) LIKE ('%' || lower(table3.lookup_value) ||
'%')
  ), table2.category)
FROM table1 JOIN table2 ON table2.psc_code = table1.product_code
WHERE date_signed = '2017-02-01';


--
View this message in context: http://postgresql.nabble.com/Conditional-Lookup-Table-with-Like-tp5944796p5944935.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql