Re: Spacing in output

Do this:

SELECT SUBSTR(prod_name,1,45) from Products;

Duane

-----Original Message-----
From: Jerome Lyles [mailto:susemail(at)hawaii(dot)rr(dot)com]
Sent: Tuesday, September 14, 2004 4:22 PM
To: pgsql-general(at)postgresql(dot)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