storj / dbx

A neat codegen-based database wrapper written in Go
Apache License 2.0
25 stars 3 forks source link

Unable to define `WHERE (fieldA, fieldB) > (?, ?)` #9

Closed mniewrzal closed 10 months ago

mniewrzal commented 10 months ago

I was unable to find a way to define something like SELECT * WHERE (fieldA, fieldB) > (?, ?)

egonelbre commented 10 months ago

I didn't test but orderby together with paged might give you what you want.

mniewrzal commented 10 months ago

it looks that if fields are primary key doing just paged give what I needed:

read paged (
    select columnA, columnB
)
mniewrzal commented 10 months ago

Its still not possible to do custom (fieldA, fieldB) > (?, ?) but I'm closing this for now as I found what was looking for.