Closed slavugan closed 2 years ago
current answer result: edgedb> SELECT (Person.name, find(Person.name, 'ma')); {('Lucy', -1), ('Count Dracula', -1), ('Crewman 1', 4)}
new answer result: edgedb> with x := (select (Person.name, find(Person.name, 'ma'))) select x.0 filter x.1 > -1; {'Crewman 1'}
missed "and" in question, so PR is wrong
current answer result: edgedb> SELECT (Person.name, find(Person.name, 'ma')); {('Lucy', -1), ('Count Dracula', -1), ('Crewman 1', 4)}
new answer result: edgedb> with x := (select (Person.name, find(Person.name, 'ma'))) select x.0 filter x.1 > -1; {'Crewman 1'}