Search Postgresql Archives

Re: || operator

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






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);
>    ?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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux