Thanks Artem. So we will have to change way we are querying. 

On Wednesday, June 4, 2014 10:32:53 AM UTC+5:30, Artem Orobets wrote:
>
> Hi Munish,
>
> SQL predicates semantic doesn't imply order. 
>
> Have you tried following?
> select from [#1:87, #1:10, #1:11]
>
>
>
> Best regards,
> Artem Orobets
>
> * Orient Technologiesthe Company behind OrientDB*
>  
>
> 2014-06-04 0:30 GMT+03:00 Munish Chopra <[email protected] <javascript:>>
> :
>
>> Hi Luca,
>>
>> My goal is to fetch multiple records in a particular order and I have 
>> their @rids.
>>
>> E.g :- Let say I have a user table
>>
>> If I do, 
>> select from user where @rid = 1:87 or @rid = 1:10 or @rid = 11
>>
>> the result will be automatically ordered as per @rid . result will be
>> @rid         name
>> 1:10            B
>> 1:11            HH
>> 1:87            hhh
>>
>> Is there a way I can get the result in the same manner I am entering the 
>> ids? i.e the result should be
>> 1:87
>> 1:10
>> 1:11
>>
>>
>> Regards,
>> Munish
>>
>> -- 
>>
>> --- 
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 

--- 
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.

Reply via email to