Hi,
My aim is to fetch all Friends for a user, which I can do with the
following
SELECT expand(both("Friend")) FROM User WHERE @rid = #27:0
# Returns 3 rows
Now I want to paginate this example lets start of by limiting
SELECT expand(both("Friend")) FROM User WHERE @rid = #27:0 LIMIT 2
# Returns 2 rows
Now lets add an offset, I now expect to get 2 rows
SELECT expand(both("Friend")) FROM User WHERE @rid = #27:0 SKIP 1 LIMIT 2
# Returns 0 rows
I'm not quite sure why I get zero rows. So I guess this means that LIMIT
applies to result set but what does SKIP apply to?
Thanks,
Jamie
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
