Thanks Paul.
but I've found a shorter way:
select count(*) as a, eval('a - 1') as result from ...
El domingo, 26 de abril de 2015, 3:17:09 (UTC-4), Rodrigo Abt escribió:
>
> Hi,
>
> First, let me tell you what an incredible discovery is this database for
> me. Coming from a MySQL background for years I was very happy to see some
> SQL dialect in OrientDB. And as a business, HR and IT consultant I'm
> constantly looking for new ways to add value to my clients and I feel that
> OrientDB fills all the gaps.
>
> I've been playing with OrientDB 2.0 for a couple of weeks, reading
> tutorials, getting familiar with traversals, Udemy and so on. I've
> successfully created a test database on my Macbook using Studio with a few
> vertexes and edges. My question is
>
> How can I substract a number from a select count(*) in OrientDB?
>
> Because when I try a query like this:
>
> select count(*)-1 as n from (traverse in("Sof") from #12:20)
>
> it gives me an error in the "count" part..but if I drop the -1 it works...
>
> Thanks in advance,
> Rodrigo Abt,
> Chile
>
--
---
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.
