select as with cases and like

Anonymous — Sat, 16 Nov 2024 02:06:16 GMT

I need to implement the following PostgreSQL query by means of Talend:

select *, (case
when product_reviews.product not like '%[^0-9]%' then cast(product_reviews.product as varchar)
when product_reviews.product like '%@%' then cast((select product_details.product_code from product_details where lower(product_reviews.product) = lower(product_details.product_ID)) as varchar)
else cast((select product_details.product_code from product_details where lower(product_reviews.product) = lower(product_reviews.product_name)) as varchar)
end) as product_code;
from product_reviews;

Re: select as with cases and like

vapukov — Thu, 25 Jun 2020 04:35:47 GMT

Hi,

what is your question (problem) exactly?

btw, at least one error there:

select 
     XXXX,
     XXXX) as product_code;
from product_reviews;

you have wrong ; after as product_code

cheers

topic Re: select as with cases and like in Talend Studio

select as with cases and like

Re: select as with cases and like