On 8/4/22 08:34, Aleš Zelený wrote:
SELECT ... simple join of two tables...
WHERE opd.id_data_provider = _id_data_provider
AND CASE WHEN _external_id IS NULL
THEN external_id IS NULL
ELSE external_id = _external_id
END
AND CASE WHEN _external_complete_id IS NULL
THEN _external_complete_id IS NULL
Unrelated to your question, but shouldn't that actually read:
AND CASE WHEN _external_complete_id IS NULL
THEN external_complete_id IS NULL
^^^
ELSE external_complete_id = _external_complete_id
END;
$function$
--
Joe Conway
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
