7 ms·

You end up doing a lot of string concatenation even with that, though. It's not quite the same thing as having some kind of literal or combinator based setup.

You end up doing a lot of string concatenation even with that, though. It's not quite the same thing as having some kind of literal or combinator based setup. select(from('tab'), where(and(like('name','Mo%'),not(is('id',NULL)))

rpedela 12y ago
You can get a similar syntax with format() by nesting format() calls such as: EXECUTE format('SELECT * FROM tab %s', format('WHERE %I IS NOT NULL', 'id'));