Do this:
SELECT SUBSTR(prod_name,1,45) from Products;
Duane
-----Original Message-----
From: Jerome Lyles [mailto:susemail@hawaii.rr.com]
Sent: Tuesday, September 14, 2004 4:22 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Spacing in output
On Tuesday 14 September 2004 11:15 am, you wrote:
> What is the field size of prod_name? You could use SUBSTR(prod_name,1,xx)
> where xx is the max number of characters you want to see.
>
> Duane
fieldsize: 255. I tried to use SUBSTR:
sql_tutorial=> SUBSTR(prod_name,1,45; SELECT prod_name FROM Products;
sql_tutorial(>
sql_tutorial(>
sql_tutorial(> SELECT prod_name FROM Products;
sql_tutorial(> SUBSTR(prod_name,1,45;
but I have the syntax wrong. What does '(>' instead of '=>' mean?
Thanks,
Jerome
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings