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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
