Joshua wrote:
Thank you all for your assistance. I did end up finding NULL in the
'onorder' column which should have been zero's this was in a test
table that happened to have some NULL in it for one reason or another
but I should not find this in the production version of the table.
I
Hello,
I am new to this list and have been working with PostgreSQL since January.
Here is my problem, I hope someone here has some experience or can point
me in the right direction. I am writing the following query for a C#
program I am writing:
SELECT 'PV.LINEITEM:' || partnum || ',' ||
SELECT 'PV.LINEITEM:' || partnum || ',' || round(onhand) || ',' ||
round(qm5) || ',' || round(lsm4) || ',' || ',' || ',' || round(onorder)
|| ',' || ',' || ',' || binone || ',' || ',' || round(backorderqty) ||
',' || ',' || round(onhold) || ',' || ',' || ',' || ',' || ',' || ',' ||
',' ||
I checked the table and found that none of my fields in the SELECT
statement contain NULLs.
Any other suggestions?
PFC wrote:
SELECT 'PV.LINEITEM:' || partnum || ',' || round(onhand) || ',' ||
round(qm5) || ',' || round(lsm4) || ',' || ',' || ',' ||
round(onorder) || ',' || ',' || ',' ||
Joshua wrote:
I checked the table and found that none of my fields in the SELECT
statement contain NULLs.
Any other suggestions?
Please post the queries you used.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 9: In versions
Joshua wrote:
I checked the table and found that none of my fields in the SELECT
statement contain NULLs.
Any other suggestions?
Why are you using such constructions in your query: ',' || ',' || ',' ?
May be this set of commas makes you think that some of your fields are
empty? Do you have