Andrus wrote: >> Use "bpchar" instead of "text" in the definition of function and operator. >> Otherwise col1 gets cast to "text" and loses its trailing spaces. > > Thank you very much. > It worked. > Which notation to use for this ? > > Is it reasonable use "+" as such operator for strings or should some other > notation used ?
The traditional concatenation operator name is ||, but I believe that it is confusing to overwrite builtin operators. You could use a name that does not show up in SELECT DISTINCT oprname FROM pg_operator; Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
