pgsql: Add string functions: concat(), concat_ws(), left(), right(), and

Lists: pgsql-committers
From: itagaki(at)postgresql(dot)org (Takahiro Itagaki)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add string functions: concat(), concat_ws(), left(), right(), and
Date: 2010-08-24 06:30:44
Message-ID: 20100824063044.381977541D7@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers

Log Message:
-----------
Add string functions: concat(), concat_ws(), left(), right(), and reverse().

Pavel Stehule, reviewed by me.

Modified Files:
--------------
pgsql/doc/src/sgml:
func.sgml (r1.529 -> r1.530)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.529&r2=1.530)
pgsql/src/backend/utils/adt:
varlena.c (r1.179 -> r1.180)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/varlena.c?r1=1.179&r2=1.180)
pgsql/src/include/catalog:
catversion.h (r1.596 -> r1.597)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.596&r2=1.597)
pg_proc.h (r1.580 -> r1.581)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h?r1=1.580&r2=1.581)
pgsql/src/include/utils:
builtins.h (r1.354 -> r1.355)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/builtins.h?r1=1.354&r2=1.355)
pgsql/src/test/regress/expected:
text.out (r1.4 -> r1.5)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/text.out?r1=1.4&r2=1.5)
pgsql/src/test/regress/sql:
text.sql (r1.4 -> r1.5)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/text.sql?r1=1.4&r2=1.5)


From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Takahiro Itagaki <itagaki(at)postgresql(dot)org>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Add string functions: concat(), concat_ws(), left(), right(), and
Date: 2010-08-24 07:30:49
Message-ID: AANLkTi=X66C=7j3yc3haQtnJ39gkSr+EFU3FVH1wCqCE@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers

Hello

documentation for left / right (negative parameters) maybe missing a
word "without (without first/last n chars). Maybe not - I am not
native speaker.

Regards

Pavel

2010/8/24 Takahiro Itagaki <itagaki(at)postgresql(dot)org>:
> Log Message:
> -----------
> Add string functions: concat(), concat_ws(), left(), right(), and reverse().
>
> Pavel Stehule, reviewed by me.
>
> Modified Files:
> --------------
>    pgsql/doc/src/sgml:
>        func.sgml (r1.529 -> r1.530)
>        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.529&r2=1.530)
>    pgsql/src/backend/utils/adt:
>        varlena.c (r1.179 -> r1.180)
>        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/varlena.c?r1=1.179&r2=1.180)
>    pgsql/src/include/catalog:
>        catversion.h (r1.596 -> r1.597)
>        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.596&r2=1.597)
>        pg_proc.h (r1.580 -> r1.581)
>        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h?r1=1.580&r2=1.581)
>    pgsql/src/include/utils:
>        builtins.h (r1.354 -> r1.355)
>        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/builtins.h?r1=1.354&r2=1.355)
>    pgsql/src/test/regress/expected:
>        text.out (r1.4 -> r1.5)
>        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/text.out?r1=1.4&r2=1.5)
>    pgsql/src/test/regress/sql:
>        text.sql (r1.4 -> r1.5)
>        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/text.sql?r1=1.4&r2=1.5)
>
> --
> Sent via pgsql-committers mailing list (pgsql-committers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-committers
>


From: Thom Brown <thom(at)linux(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Takahiro Itagaki <itagaki(at)postgresql(dot)org>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Add string functions: concat(), concat_ws(), left(), right(), and
Date: 2010-08-24 09:40:51
Message-ID: AANLkTi=zWO5Wt-X0Bo_u3dY5ghAux+tQvu0xMWEYgZq0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers

On 24 August 2010 08:30, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> Hello
>
> documentation for left / right (negative parameters) maybe missing a
> word "without (without first/last n chars). Maybe not - I am not
> native speaker.

You mean "Return without first n characters in the string."? No, that
wouldn't make sense.

--
Thom Brown
Registered Linux user: #516935