Postgres Pro
Downloads
Home   >   mailing lists

Thread: zero length string to zero

zero length string to zero

From
Shadi Mal
Date:
Hi,
 I get zero length string in my result but I want to have zero value instead.
what can I do?
my query is:
         Count(unreadmandatory.course) AS nbrofmandatoryleft
           FROM unreadmandatory
          GROUP BY unreadmandatory.id

Re: zero length string to zero

From
Adrian Klaver
Date:
On 04/20/2016 05:31 AM, Shadi Mal wrote:
> Hi,
>   I get zero length string in my result but I want to have zero value
> instead.
> what can I do?
> my query is:
> SELECT unreadmandatory.id <http://unreadmandatory.id>,
>           Count(unreadmandatory.course) AS nbrofmandatoryleft
>             FROM unreadmandatory
>            GROUP BY unreadmandatory.id <http://unreadmandatory.id>

What is the type of unreadmandatory.id?

And are you getting an empty string or NULL?


--
Adrian Klaver
adrian.klaver@aklaver.com