> 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 s
> 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 search_graph(id
> 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 example in the doc
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 has a distance numer
Hi.
i use postgresql 9.6.3.
I have made a small graph with nodes and edges. Each edge has a distance
numeric (7,3) attribute.
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 typ
