Model

Normally, for case insensitive where queries, you can use the ‘ILIKE’ operator. But if you’re linking a prepopulated dataset, there’s a chance where a foreign key string doesn’t quite match another table’s key. There’s not too much info on getting case insensitive relationships working other than digging into the database dictionary and building your own … Read more