Le 06/09/2017 à 18:13, Cédric Krier a écrit :
The print statement pretty much shows the query I intended though what I don't
get now is why python-sql needs the 'distinct_on' clause to avoid excessive
output...
that is, neither psql nor phppgadmin sql need it to work correctly.
Is this an anomalie that perhaps should have an issue filed?
It is difficult to say it without seeing the executed SQL.
This was due to evolution of my test program and the addition of account_move
in order
to filter out the bogus builtin journals from openerp (which seem to exist as
well in tryton).
THe distinct is thus correctly needed. sorry for the noise.
Do I understand therefore that aliasing is indeed not supported on tables (that
is, only on columns)?
cheers,
--
Richard PALO
--
You received this message because you are subscribed to the Google Groups
"python-sql" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to python-sql+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
