Re: Momjian "Support Functions" section: possible typo and question

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Momjian "Support Functions" section: possible typo and question
Дата
Msg-id 200201081952.g08Jq7j18011@candle.pha.pa.us
обсуждение исходный текст
Ответ на Momjian "Support Functions" section: possible typo and question  (Terrence Brannon <metaperl@mac.com>)
Список pgsql-sql
Terrence Brannon wrote:
> I am reading the Momjian "Support Functions" section and have the 
> following comments:
> 
> 1 - there is a comma after "BOTH" that is not before "LEADING" or 
> "TRAILING", so I believe it is an error.
> 
> ?    trim(BOTH...)    trim(BOTH, col)    same as trim()
> ?    trim(LEADING...)    trim(LEADING col)    col with leading spaces 
> removed
> ?    trim(TRAILING...)    trim(TRAILING col)    col with trailing 
> spaces removed

Thanks.  The BOTH, is wrong, it should be just BOTH.  I have updated the
book web site with this error.

> 2 - I typed \h trim and no help came up. Is it required to resort 
> to HTML documentation for docs on this function

TRIM is an ANSI word that masks several functions like rtrim, ltrim, and
btrim.  \df rtrim shows these.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-sql по дате отправления:

Предыдущее
От: Frank Bax
Дата:
Сообщение: Re: simple? join
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: Porting Oracle Packages