Re: [SQL] problems with SELECT query results

2007-05-29 Thread Richard Broersma Jr
--- Joshua <[EMAIL PROTECTED]> wrote: > Hello, > > 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 i

Re: [SQL] problems with SELECT query results

2007-05-29 Thread Joshua
Hello, 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 also app

Re: [SQL] problems with SELECT query results

2007-05-29 Thread Richard Huxton
Joshua wrote: 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:' || partnu

[SQL] problems with SELECT query results

2007-05-29 Thread Joshua
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 || ',' || rou