demo (#22) - pgrouting diagnostic tool (#385) - Message List

pgrouting diagnostic tool

hello admin...

can you help me, i have problem with this

alter table vertices_tmp add column cnt integer;
update vertices_tmp set cnt=0;
update vertices_tmp set cnt=cnt+1 where streets.source=id;
update vertices_tmp set cnt=cnt+1 where streets.target=id;

i don't understand with syntax [ where streets.source=id ] can you explain to me? thanks for your answer. God bless uu

  • Message #1640
    WHERE streets.source=id
    

    is SQL syntax for

    WHERE <table>.<attribute>=<value>
    

    You don't need "<table>." if the table name is clear.

  • Message #1649

    ok daniel thanks for your response...