SELECT 'PV.LINEITEM:' || partnum || ',' || round(onhand) || ',' ||
round(qm5) || ',' || round(lsm4) || ',' || ',' || ',' || round(onorder)
|| ',' || ',' || ',' || binone || ',' || ',' || round(backorderqty) ||
',' || ',' || round(onhold) || ',' || ',' || ',' || ',' || ',' || ',' ||
',' || round(qtyperjob) || ',' || round(ordermax) AS gmrim FROM slparts
WHERE vendor LIKE 'CH%'
You could select columns and build the string in your application ?
The query does work and I am getting results from the database. There
are values for all 'partnum' in the database, however, the query results
include blank fields here and there in between the returned records. Why
am I receiving blank fields for 'gmrim'???? This absolutely defies logic
Because one of your fields is probably NULL, and NULL || anything stays
NULL.
You have probably been misled to believe they are "blanks" because they
don't display as "NULL" but as "".
I set psql to display NULL as NULL.
If these columns can, must, or should not contain NULLs depends on your
application... it's for you to chose.
Use COALESCE, add NOT NULL constraints, grab the columns and build the
string in your application, you chose.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
