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 по дате отправления: