Re: Spacing in output
От | Duane Lee - EGOVX |
---|---|
Тема | Re: Spacing in output |
Дата | |
Msg-id | 64EDC403A1417B4299488BAE87CA7CBF01CD0FA7@maricopa_xcng0 обсуждение исходный текст |
Ответ на | Spacing in output (Jerome Lyles <susemail@hawaii.rr.com>) |
Ответы |
Re: Spacing in output
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: