On Tue, Sep 14, 2004 at 06:37:40PM -1000, Jerome Lyles wrote: > On Tuesday 14 September 2004 11:27 am, David Fetter wrote: > > On Tue, Sep 14, 2004 at 11:05:46AM -1000, Jerome Lyles wrote: > > > I have a small training database: sql_tutorial. It works fine > > > but the spacing between the output lines is too much. This is > > > the way it looks when I copy and paste from the Konsole to this > > > email:
> > > sql_tutorial=> SELECT prod_name FROM Products; > > > > Is prod_name a char(n) for some large n? > > > > Cheers, > > D > char(255) Well, Don't Do That, Then. TEXT is a great type for storing text. VARCHAR(n) is a TEXT with a maximum length constraint, and CHAR(n) (fixed length) is pretty nearly obsolete. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
