Simplifying further still, even this does not work...
*select in('town_has_zipcode')[0].zip as test from #40:123 where test =
'LA90019'*
On Tuesday, August 4, 2015 at 11:47:52 PM UTC+1, Simon White wrote:
>
> I know I am being stupid but could anyone help me with a simple select
> statement spanning multiple edges?
>
>
> I have a model which looks like PERSON -> TOWN <- ZIPCODE
>
> I am trying to select all the people that live in a named zip code but I
> am getting no matches...
>
> *select out('person_lives_in_town').in('town_has_zipcode')[0].zip from
> person where zip= 'LA90019'*
>
> if I do *select from town where zip = 'LA90019'* it returns the single
> zip vertex as expected
> if I do *select out('person_lives_in_town').in('town_has_zipcode')[0].zip*
> from person it returns a list of zip code names as expected
>
> (Note: I am unable to reverse the query to travel from zip codes back to
> people (which logically may make more sense) because the real model is
> actually a bit more complicated and various timestamps are involved,
> hopefully this is a good enough demonstration example though)
>
--
---
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.
