Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.