Re: SQl help to build a result with custom aliased bool column

Hi,

Thanks for showing different ways to achieve the goal. So what should be the optimal way to solve this. I have an
compositeindex using company_id and feature_id columns for project_features table. 

I do ruby on rails development, where table names are plural always by convention. The tables I created above in
differentschema to ask question with sample data and test the query output. So they are little inconsistent, yes you
areright. 

Thanks,

Arup Rakshit
ar@zeit.io



> On 08-Apr-2019, at 4:36 PM, mariusz <marius@mtvk.pl> wrote:
>
> bear in mind that with a large number of companies and proper index on
> company_features the optimizer could limit company_features as
> necessary, while your examples read everything anyway and mangle output
> to get proper result (with dups and bugs, but also not optimal)