<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 14/06/13 14:19, Daniel Kastl wrote:<br>
<br>
I can try and have a play, my problem being that I am more a
C/java programmer than an sql programmer. I prefer to deal with
standard sql constructs rather that data base specfic stuff.<br>
<br>
I can see why you got for the matrix solution, if avoid all those
node/hash lookup problems.<br>
<br>
If coding an select * from xyz solution , you have to deal with
the case that a node may be any number in the range 1-32^2 and
that has to be mapped on to an array of given size by using some
type of hashing function and a reverse lookup has to be done on
the return.<br>
<br>
The store procedure has its attractions because its version
neutral, it will work as well on linix box as well as a Windoz
box.<br>
<br>
I see what I can come up with.<br>
<br>
DAve.<br>
<em style="font-weight: bold; font-style: normal; color: rgb(68,
68, 68); font-family: arial, sans-serif; font-size: small;
font-variant: normal; letter-spacing: normal; line-height: 16px;
orphans: auto; text-align: left; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255);"></em><span style="color: rgb(68, 68, 68); font-family:
arial, sans-serif; font-size: small; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: 16px; orphans: auto; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); display: inline !important; float: none;"><span
class="Apple-converted-space"> </span></span></div>
<blockquote
cite="mid:CABXBSH_k0gNQQAWYVkXencVLETJxffxfQROKbzTZ11QUBnG5vg@mail.gmail.com"
type="cite">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Fri, Jun 14, 2013 at 10:07 PM,
Stephen Woodbridge <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Dave,<br>
<br>
I'm not totally opposed to this, but I would like to
discuss how you plan to structure the data and what your
query would look like.<br>
<br>
There is another possibility that I like better and that
would be to write stored procedure that takes you sql
query and returns a matrix.<br>
<br>
matrix[][] pgr_matrix(sql text)<br>
<br>
Then you can do something like:<br>
<br>
select * from pgr_tsp(pgr_matrix('select * from
matrix_table'), 27);<br>
<br>
</blockquote>
<div><br>
</div>
<div style="">This idea I really like, because we might also
be able to use it then for Razequl's VRP solver.</div>
<div style=""><br>
</div>
<div style="">Daniel</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div> </div>
</div>
-- <br>
<span
style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic
UG & Georepublic Japan<br>
eMail: <a moz-do-not-send="true"
href="mailto:daniel.kastl@georepublic.de"
style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a moz-do-not-send="true" href="http://georepublic.de/"
style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgrouting-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgrouting-dev@lists.osgeo.org">pgrouting-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev">http://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>