2014-09-04 6:27 GMT+02:00 Vinayak <vinpokale@xxxxxxxxx>:
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.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
