Re: [SQL] Blank-padding

2005-10-24 Thread Shaun Watts
ng that is being stored. So it is stored as "abc " instead of "abc". I don't want that padding there. I am fairly new to Postgres and have only dealt with Informix database systems, which don't store data this way. Any help is very much appreciated. Thanks, Shau

[SQL] selecting problems

2003-10-31 Thread Shaun Watts
What I am trying to do is select all the rows out of the categories table (see below) and select the sum of j_amount out of the judgment table. Right now it is only returning the categories that are in the judgment table. I want it to return those fields with the amounts out of the judgment tabl