pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Momjian "Support Functions" section: possible typo and question 2+ messages / 2 participants [nested] [flat]
* Momjian "Support Functions" section: possible typo and question @ 2002-01-08 16:35 Terrence Brannon <metaperl@mac.com> 2002-01-08 19:52 ` Re: Momjian "Support Functions" section: possible typo and question Bruce Momjian <pgman@candle.pha.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Terrence Brannon @ 2002-01-08 16:35 UTC (permalink / raw) To: pgsql-sql 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 2 - I typed \h trim and no help came up. Is it required to resort to HTML documentation for docs on this function ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Momjian "Support Functions" section: possible typo and question 2002-01-08 16:35 Momjian "Support Functions" section: possible typo and question Terrence Brannon <metaperl@mac.com> @ 2002-01-08 19:52 ` Bruce Momjian <pgman@candle.pha.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Bruce Momjian @ 2002-01-08 19:52 UTC (permalink / raw) To: Terrence Brannon <metaperl@mac.com>; +Cc: 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, Pennsylvania 19026 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-01-08 19:52 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-01-08 16:35 Momjian "Support Functions" section: possible typo and question Terrence Brannon <metaperl@mac.com> 2002-01-08 19:52 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox