2014-09-04 6:27 GMT+02:00 Vinayak <vinpok...@gmail.com>: > Hello Pavel, > > Thank you for reply. > >postgres=# select 'abc '::char(7) || 'dbe '::char(6); > > ?column? > >---------------- > > *abc abc* > >(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; is wrong should be 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
