From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Terrence Brannon <metaperl(at)mac(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Momjian "Support Functions" section: possible typo and question |
Date: | 2002-01-08 19:52:07 |
Message-ID: | 200201081952.g08Jq7j18011@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Cunningham | 2002-01-08 20:23:52 | Re: [SQL] Need help |
Previous Message | Frank Bax | 2002-01-08 19:03:19 | Re: simple? join |