Robin Moffatt
03/15/2023, 6:58 AMAriel Shaqed (Scolnicov)
03/15/2023, 7:04 AMRobin Moffatt
03/15/2023, 8:02 AMOz Katz
03/15/2023, 10:31 AMRobin Moffatt
03/15/2023, 10:44 AMlakefs_object
was a macro, etc.Oz Katz
03/15/2023, 10:45 AMRobin Moffatt
03/15/2023, 10:46 AMILIKE
🤯Ariel Shaqed (Scolnicov)
03/15/2023, 10:46 AMRobin Moffatt
03/15/2023, 10:47 AMOz Katz
03/15/2023, 10:55 AMILIKE
is ansi sql, but many databases support it.Ariel Shaqed (Scolnicov)
03/15/2023, 10:58 AMThe key wordcan be used instead ofILIKE
to make the match case-insensitive according to the active locale. This is not in the SQL standard but is a PostgreSQL extension.LIKE
Robin Moffatt
03/15/2023, 11:24 AMYes, I think it's worth opening an issue for it.logged https://github.com/duckdb/duckdb/issues/6729