Thanks Kyle for your relevant answer. On Wednesday, April 15, 2015 at 10:03:44 PM UTC+2, Kyle wrote: > > I'm not entirely certain what your expected input/output is. > > Notice in the tutorial the "expand" function was used. > http://orientdb.com/docs/last/SQL-Functions.html#expand > > so > select expand(in()) from Restaurant where name = 'Dante' > instead of > select in() from Restaurant where name = 'Dante' > > orientdb> select in() from Restaurant where name = 'Dante' > > +-------+----------------+ > | @RID | in | > +-------+----------------+ > | #-2:1 | [#11:0, #11:1] | > +-------+----------------+ > > the [2] in your screenshots is a shorted version of the [#11:0, #11:1] > above. > > so try: > > orientdb> select expand( in() ) from Restaurant where name = 'Dante' > > +-------+-------------+-------------+---------+ > | @RID | @CLASS | Name | out_Eat | > +-------+-------------+-------------+---------+ > | #11:0 | Person | Luca | #12:0 | > | #11:1 | Person | Bill | #12:0 | > +-------+-------------+-------------+---------+ > > > hope that is helpful! > > On Wednesday, April 15, 2015 at 3:12:19 AM UTC-7, KY wrote: >> >> Hi, >> >> Here all the details. >> - installed orientdb-2.0.6 on my windows 7-64bit >> - followed the tutorial: >> http://orientdb.com/docs/last/Tutorial-Using-schema-with-graphs.html >> and created a new db: create database >> plocal:../databases/WorkingWithGraphs admin admin plocal >> - connected to the new db: connect plocal:../databases/WorkingWithGraphs >> admin admin >> >> - created Person, Restaurant and Eat classes: >> create class Person extends V >> create class Restaurant extends V >> create class Eat extends E >> >> - populated the db as described (create vertex, create edge) >> >> - executed two queries: >> select from Restaurant => select-restaurant-in_Eat screenshot >> select in() from Restaurant where name = 'Dante' => select-in-restaurant >> screenshot >> >> Thanks! >> >> On Wednesday, April 15, 2015 at 10:30:17 AM UTC+2, [email protected] >> wrote: >>> >>> Hi, >>> >>> I've created the schema with Restaurant/Person/Eat and populated the >>> base as described in the tutorial with release 2.0.6. >>> >>> I don't see any columns in Restaurant or Person called in_Eat or out_Eat. >>> >>> *select in() from Restaurant where name = 'Dante'* returns a list of >>> Person as expected. >>> >>> Where do you see @class = null and what is this in/out = 0/1 ? >>> >>> Regards. >>> >>
-- --- 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.
