Re: [GENERAL] How to perform text merge

2010-03-29 Thread Harald Fuchs
In article <609bf3ce079445569fc0d047a5c81...@andrusnotebook>, "Andrus" writes: > Database column contains merge data in text column. > Expressions are between << and >> separators. > How to replace them with database values ? > For example, code below should return: > Hello Tom Lane! > How to

Re: [GENERAL] How to perform text merge

2010-03-28 Thread Andrus
Since you pretty much invented your own language Expressions are in PostgreSql syntax. I expected that there is some way to force PostgreSql to evaluate them at runtime using something like pgsql EXECUTE For example, 'Hello <>!' should be converted (inverted) to 'Hello ' || firstname||' '||l

Re: [GENERAL] How to perform text merge

2010-03-28 Thread Alban Hertroys
On 28 Mar 2010, at 19:43, Andrus wrote: > Database column contains merge data in text column. > Expressions are between << and >> separators. > How to replace them with database values ? > > For example, code below should return: > > Hello Tom Lane! > > How to implement textmerge procedure or o

[GENERAL] How to perform text merge

2010-03-28 Thread Andrus
Database column contains merge data in text column. Expressions are between << and >> separators. How to replace them with database values ? For example, code below should return: Hello Tom Lane! How to implement textmerge procedure or other idea ? Andrus. create temp table person ( firstname