Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set.

I am using a Native OLE DB\PostgreSQL Native Provider as a connection to the database and other key words are working correctly.

I run the query in PGAdminIII and it returns a numeric data type.

I re-enginered the query to use a case when statement, but its still producing a negative value.

share|improve this question
What is your query ? – Luc M Aug 5 '10 at 14:26
Is it a changing negative number? – Sam Aug 5 '10 at 17:42

We spoke to the PGNP team and it was a problem with the provider that we are using. Its a known problem and will be resolved shortly.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.