Re: [GENERAL] concat strings but spaces

2004-04-06 Thread Ron St-Pierre
Matthias Teege wrote: Moin, I try to concat values from three fields in a function like this: create or replace function fconcat_name(varchar, varchar, varchar) returns varchar as ' declare ttl alias for $1; vnm alias for $2; nme alias for $3; begin return ttl || '' '' || vnm || ''

Re: [GENERAL] concat strings but spaces

2004-04-06 Thread Joe Conway
Matthias Teege wrote: I try to concat values from three fields in a function like this: create or replace function fconcat_name(varchar, varchar, varchar) returns varchar as ' declare ttl alias for $1; vnm alias for $2; nme alias for $3; begin return ttl || '' '' || vnm || '' ''