25.03.2015 19:43, 'checkmail' wrote:

> one short question, why is the Result of
> coalesce(:variableVarchar(10),‘NULL‘) not ‚NULL‘ but rather ‘NULL ‘
> with blanks from varchar(10) length?

Because the resulting length is determined by the longest argument. It's
fixed at the compile time.


Dmitry