Re: || operator

On Wed, 2014-09-03 at 21:27 -0700, Vinayak wrote:
> 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".
>
>
I believe there was a typo in the function, try this one
:
postgres=# 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.
>
>

Important Notice: The contents of this email are intended solely for the named addressee and are confidential; any unauthorised use, reproduction or storage of the contents is expressly prohibited. If you have received this email in error, please delete it and any attachments immediately and advise the sender by return email or telephone.

Deakin University does not warrant that this email and any attachments are error or virus free.