Re: Outputting Standard SQL

2019-08-25 Thread Vik Fearing
On 25/08/2019 21:14, Tom Lane wrote: > Vik Fearing writes: >> EXPLAIN (COSTS OFF) SELECT * FROM pg_am WHERE amname LIKE '%t%'; >>     QUERY PLAN >> --- >>  Seq Scan on pg_am >>    Filter: (amname ~~ '%t%'::text) >> (2 rows) >> Why don't we conver

Re: Outputting Standard SQL

2019-08-25 Thread Tom Lane
Vik Fearing writes: > EXPLAIN (COSTS OFF) SELECT * FROM pg_am WHERE amname LIKE '%t%'; >     QUERY PLAN > --- >  Seq Scan on pg_am >    Filter: (amname ~~ '%t%'::text) > (2 rows) > Why don't we convert that back to LIKE? Trying to do so would m