), where it
gives 1 where are NULL and 1 in column x. Probably you should introduce
coalesce() here.
Thank you,
Petr
On 29.7.2013 22:55, Petr Chmelar wrote:
Dear Pavel and Andrew,
avoiding the nulls solves the thing - thank you! I was considering
NULL as 0... lame.
I just wonder why i
Dear Pavel and Andrew,
avoiding the nulls solves the thing - thank you! I was considering NULL
as 0... lame.
I just wonder why it was working in the console, but it is not important
- at the moment it works just fine.
Cheers,
Petr
On 27.7.2013 22:59, Pavel Stehule wrote:
Hello
2013/7/27 An
Dear Briklen and Pavel,
Yes, the z. is a typo, it should be z.z ... I can send the complete query and
tables tomorrow, also I'll try to make it simpler (the function is about 300
lines).
Thanks for the early answers,
Petr
Dne 24.07.2013 17:14 napsal uživatel bricklen:
On Wed, Jul 24, 2013 at 7