On Tuesday 21 October 2003 14:58, Wilhelm Graiss wrote:
> heute := ''today'';
> Select Into vk ourcolumn From table where other = foo;
> If vk > 0 Then
> vk_txt := ''Vorkuehlung notwendig'';
> ez := heute + interval ''vk days'';
> The variable 'heute' is declared as timestamp,
> 'vk' as integer!
>
> What have we done wrong??
Quoted the vk variable. You want something like:
ez := heute + (vk || '' days'')::interval;
--
Richard Huxton
Archonet Ltd