> 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
'Hello <<firstname||'' ''||lastname>>!'
should be converted (inverted) to
'Hello ' || firstname||' '||lastname || '!'
and then pgsql EXECUTE can be used to perform text merge just like .asp
pages are pre-processed and compiled.
How to do this is PostgreSql or in C# in MONO/.NET ?
> Personally I think you're using a bad example here, as usually names don't
> just involve firstname and surname, but frequently have infixes, suffixes
> and titles and such. Not all of those fields are going to have values for
> every person in your database. What happens if you don't have a Tom Lane,
> but a mr. Lane, or if you have both but want to address a person more
COALESCE(), CASE WHEN and other pgsql constructs can be used to create
correct address expressions from any data.
In response to
pgsql-general by date
|Next:||From: Andrus||Date: 2010-03-28 20:48:28|
|Subject: Re: Splitting text column to multiple rows|
|Previous:||From: Faheem Mitha||Date: 2010-03-28 20:05:31|
|Subject: Re: simultaneously reducing both memory usage and runtime
for a query |