[GRASS-dev] db.join script wanted

Paulo van Breugel p.vanbreugel at gmail.com
Wed Mar 9 11:11:33 PST 2016


On Wed, Mar 9, 2016 at 7:14 PM, Luca Delucchi <lucadeluge at gmail.com> wrote:

> On 9 March 2016 at 19:11, Markus Neteler <neteler at osgeo.org> wrote:
> >
> >
> > Yeah.. I think
> > LEFT OUTER JOIN
> > must be used, at least with sqlite backend.
>

The code now assumes a 1:1 relationship, is that right?

so if Table 1
A|B
1|2
2|2

and Table 2
A|C
1|3
1|4
2|6

After joining Table 1 looks like

A|B|C
1|2|3
2|2|6

If correct, it might be good to clearly explain this in the documentation?
I wouldn't mind doing that if a final version is ready. At some point it
might be a nice feature to have the option to select the kind of
relationship. On the other hand, that may complicate things to the point
that one may as well use db.execute.



> >
>
> no, the code is working quiet well, look to m other mail. it seems a
> column type problem
>
>
> --
> ciao
> Luca
>
> http://gis.cri.fmach.it/delucchi/
> www.lucadelu.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-dev/attachments/20160309/8d51165a/attachment.html>


More information about the grass-dev mailing list