On Wed, Mar 9, 2016 at 7:14 PM, Luca Delucchi <[email protected]> wrote:
> On 9 March 2016 at 19:11, Markus Neteler <[email protected]> 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 >
_______________________________________________ grass-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-dev
