Hi,
Is there a rownum function to be able to assign a row number to every
record returned from a query?
Say I have two documents: {fname: fname1, lname: lname1} and {fname:
fname2, lname: lname2}
Is it possible to do something of the sort and get the output like below?
for d in mycoll
return {myrownnum: ROW_NUMBER(), fname: d.fname, lname: d.lname}
Expected output:
{myrownum: 0, fname: fname1, lname: lname1}
{myrownum: 1, fname: fname2, lname: lname2}
I understand that it would probably not work (i.e. would give wrong rownums
or plainly not work) in a clustered environment and that you haven't
specified the shard keys completely. But I think it should b possible when
you hit a single shard.
--
You received this message because you are subscribed to the Google Groups
"ArangoDB" 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.
