ET08/25/2020, 7:31 AM
I get this error : "Error: near "EXISTS": syntax error" Maybe do you have a different solution instead of "EXISTS" ?
EXISTS(SELECT size from file where path = '/tmp/et.txt')
ET08/25/2020, 1:16 PM
SELECT 'true' AS is_present FROM file WHERE path = '/tmp/et.txt'
logic as follows:
SELECT CASE WHEN (SELECT 1 FROM file WHERE path = '/tmp/et.txt') THEN 'true' ELSE 'false' END AS file_present
ET08/25/2020, 1:29 PM