lelit/pglast

Improve SubLink printer

lelit opened this issue · 0 comments

lelit commented

Add a space after LIKE here:

$ pgpp -S "select t1.* from tab1 as t1 where t1.code like (select t2.code||'.%' from tab1 t2 where t2.id = 'foo')"
SELECT t1.*
FROM tab1 AS t1
WHERE t1.code LIKE(SELECT t2.code || '.%'
                   FROM tab1 AS t2
                   WHERE t2.id = 'foo')