Re: [GENERAL] cast issue in WITH RECURION

2017-08-04 Thread k b
> 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

Re: [GENERAL] cast issue in WITH RECURION

2017-08-03 Thread k b
> 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

Re: [GENERAL] cast issue in WITH RECURION

2017-08-03 Thread Alban Hertroys
> 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

Re: [GENERAL] cast issue in WITH RECURION

2017-08-03 Thread k b
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