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.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to