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
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
This is a minor gripe in the grand scheme of things, but I'm a little
annoyed that we accept standard SQL but then don't spit it back out.
For example:
```
EXPLAIN (COSTS OFF) SELECT * FROM pg_am WHERE amname LIKE '%t%';
QUERY PLAN
---
