On Thu, Jun 7, 2018 at 4:37 PM, Melanie Plageman <melanieplage...@gmail.com> wrote:
> CREATE TABLE test1 ( > a text COLLATE "de_DE", > b text COLLATE "es_ES", > ... > ); > > My thought was to add the following example: > > SELECT a < (select 'foo' COLLATE "fr_FR") FROM test1; > > I thought this would error out because the subquery's result is considered > implicit and, in this case, it seems you now have conflicting implicit > collations. However, this does not produce an error. What am I missing? > ​Data, apparently...I got the same non-error result before inserting a record into test1 then I got the expected error. Its the function/operator the fails when faced with invalid input, not the planner, so the error requires data to provoke. David J.