Re: || operator
| От | Pavel Stehule |
|---|---|
| Тема | Re: || operator |
| Дата | |
| Msg-id | CAFj8pRDhj0kLw4y9yHXkjbCjQzxHaiXNC2RFbXLc_HB4aB8+hA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: || operator (Vinayak <vinpokale@gmail.com>) |
| Ответы |
Re: || operator
Re: || operator |
| Список | pgsql-general |
2014-09-04 6:27 GMT+02:00 Vinayak <vinpokale@gmail.com>:
Hello Pavel,
Thank you for reply.>postgres=# select 'abc '::char(7) || 'dbe '::char(6);> *abc abc*
> ?column?
>----------------
>(1 row)
but it gives the result "abc abc". It should be "abc dbe".
yes
create or replace function concat_character(character, character) returns text as $$ select concat($1,$1)$$ language sql;
create or replace function concat_character(character, character) returns text as $$ select concat($1,$1)$$ language sql;
is wrong
should be
create or replace function concat_character(character, character) returns text as $$ select concat($1,$2)$$ language sql;
create or replace function concat_character(character, character) returns text as $$ select concat($1,$2)$$ language sql;
-----
Regards,
Vinayak,
--
View this message in context: http://postgresql.1045698.n5.nabble.com/operator-tp5817541p5817674.htmlSent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: