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 composite index 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 different schema to ask question with sample data and test the query output. So they are little inconsistent, yes you are right.

Thanks,

Arup Rakshit
ar(at)zeit(dot)io

> On 08-Apr-2019, at 4:36 PM, mariusz <marius(at)mtvk(dot)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)