[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