>So that in all cases, "value" contains the value of stats.quantity when
>the selected month shows up in the iteration loop, and Zero
>when any other month shows up, so Summing the values (or indeed doing any
>other kind of aggregate function on it) will only affect
>stats.quantity values for the s
On 2013/12/22 20:53, James K. Lowden wrote:
Similarly any attribute can be Boolean if it is found to be an
attribute of an object. Giuseppe is not Boolean, but he is human and
likely male, so that: (Giuseppe = Human) is true or 1, and
(Giuseppe = Female) is false or 0.
For RDBMS and indeed mo
On 2013/12/22 09:55, Giuseppe Costanzi wrote:
I don't know if I have understood well but the statment
SUM(stats.quantity * (stats.which_month = 1))
SUM(stats.quantity * (stats.which_month = 2))
should be interpreted
SUM stats.quantity IF stats.which_month = 1 is TRUE
SUM stats.quantity IF stat
On Sun, 22 Dec 2013 05:35:55 +0200
RSmith wrote:
> Similarly any attribute can be Boolean if it is found to be an
> attribute of an object. Giuseppe is not Boolean, but he is human and
> likely male, so that: (Giuseppe = Human) is true or 1, and
> (Giuseppe = Female) is false or 0.
>
> For RDBMS
On Sun, Dec 22, 2013 at 1:05 PM, jitendar kumar wrote:
>
> My concern is not only about the memcpy in sqlite3ExprAlloc().
>
> Do any other memcpy() instance present in source code "safe" from condition
> where memcpy() having src=NULL and length !=0.
>
Dunno. Probably not, as the scan-build
Dear Mr Richard,
Thanks for the information.
My concern is not only about the memcpy in sqlite3ExprAlloc().
Do any other memcpy() instance present in source code "safe" from condition
where memcpy() having src=NULL and length !=0.
Regards,
Jitendar Kumar
__
On 22-12-2013 08:55, Giuseppe Costanzi wrote:
I don't know if I have understood well but the statment
SUM(stats.quantity * (stats.which_month = 1))
SUM(stats.quantity * (stats.which_month = 2))
should be interpreted
SUM stats.quantity IF stats.which_month = 1 is TRUE
The original '(stats.wh
7 matches
Mail list logo