Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Column Widths
...I'm a newbie to this stuff so bare with me.. Rather than try to explain that, let me ask the question differently. Is there a way to stipulate the width of a column (for the query's output) when creating the query?- pacard
- Post #3
- Forum: PostgreSQL Inc.: PostgreSQL
-
Column Widths
every time I format a column and save it, provided I don't change any aspect of the query, the columns width remain as saved. Once I change something in the query, the columns display wider than originally set. Is there a way to set default column widths so that changing a date (for instance)...- pacard
- Thread
- Replies: 2
- Forum: PostgreSQL Inc.: PostgreSQL
-
Column Widths
I'm working in postgresql. every time I format a column and save it, provided I don't change any aspect of the query, the columns will display as originally set. Once I change something in the query, the columns display wider than originally set. Is there a way to set default column widths so... -
Rookie In Need..
thanks to everyone for helping! The "and/or" did it!...amazing how a couple missed brackets can screw everything up. Thanks again, pc -
Rookie In Need..
Thanks Mercury, but that didn't do it. Let me try approaching this a different way... I asked the database to give me records where the transaction date is between the movein & moveout date using this: AND t.trans_date BETWEEN o.move_in and o.move_out The problem is that it only responded w/... -
Rookie In Need..
Thanks George. Bearing in mind this is all new to me... 1. This is PostGrSql. (a bit more disclosure) 2. When I add the column to the table as best as I can tell, I would do it like this: ALTER TABLE trans ADD unit_id INT(20) 3. DB Behavior Question- will the database only populate... -
Rookie In Need..
gmmastros, I don't have a unit_id in the trans table. unit_id only appears in the units table or occupants table...Any suggestions? -
Rookie In Need..
Hey PH, Thanks for trying. That didn't work. I'm still getting the same duplicate payments....Any other ideas? -
Rookie In Need..
Hello All-Hoping for a little guidance. I'm trying to generate a list of persons, their property, unit and their payments within a date range. My problem is that the payments are being duplicated if they lived in more than one unit. Is there a way to only include those units that actually had...
