On 01/09/2017 01:33 AM, Job wrote:
Hi guys,
Really thank you.
Thanks to your help i solved the problem.
For the record which problem(s)?:
1) Your original function issue.
2) The stand alone query you showed later.
3) Both.
As said by Adrian:
Caveats, it is morning here and coffee is still brewing, but I am not following. The left join limits grulist.stato to NULL, 1, 2. Your first condition catches the 1 value. Should not the second 'and' be (stato = 2 or stato is >>
null). In fact I do not see why it needs to exist at all, which seems to be borne out by your experimentation.
O doubled conditions, without reason!
I think making good queries is an art, at the moment i am not an artist! :)
Again,thank you very much!
/F
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
