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

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

In response to

Browse pgsql-sql by date

  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