cHef.41000
cHef.41000
PostsComments
DTDrizzle Team
Created by cHef.41000 on 7/23/2023 in #help
Order by multiple computed columns
The generated sql looks like this when I only order by one calculated column. 
select "id", "col1", "col2",  similarity( col1, $1), similarity( col2, $2 )
        from "my_schema"."my_view"
        where col1 % $3 OR col2 % $4
        order by similarity("my_view"."col1", $5) desc
        limit $6
select "id", "col1", "col2",  similarity( col1, $1), similarity( col2, $2 )
        from "my_schema"."my_view"
        where col1 % $3 OR col2 % $4
        order by similarity("my_view"."col1", $5) desc
        limit $6
2 replies
DTDrizzle Team
Created by pdina on 5/18/2023 in #help
Create GIN index in Postgres
@pdina
10 replies
DTDrizzle Team
Created by pdina on 5/18/2023 in #help
Create GIN index in Postgres
Did you just manually add the index line to the migration .sql file?
10 replies
DTDrizzle Team
Created by pdina on 5/18/2023 in #help
Create GIN index in Postgres
Did you figure anything out for this?
10 replies