> when i
create a recursive query and try to
add the distances i get
a message:
> ERROR: recursive query
"edges" column 3 has type numeric(7,3)
in
non-recursive term but type numeric
overall.
> My exercise is almost
identical to the example in the docs:
>
WITH RECURSIVE
> when i
create a recursive query and try to add the distances i get
a message:
> ERROR: recursive query
"edges" column 3 has type numeric(7,3) in
non-recursive term but type numeric overall.
> My exercise is almost
identical to the example in the docs:
>
WITH RECURSIVE
> On 3 Aug 2017, at 20:22, k b wrote:
>
> when i create a recursive query and try to add the distances i get a message:
> ERROR: recursive query "edges" column 3 has type numeric(7,3) in
> non-recursive term but type numeric overall.
> My exercise is almost identical to the
Den tors 2017-08-03 skrev k b :
Ämne: cast issue in WITH RECURION
Till: pgsql-general@postgresql.org
Datum: torsdag 3 augusti 2017 20:22
Hi.
i use postgresql 9.6.3.
I have made a small graph with nodes
and edges. Each edge