var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Conversion from smallint to char
Could anybody say me how to convert smallint value to char ?
For example if:
cost.amount - smallint
print.laber - char
how I can update print.label with cost.amount. I couldn't find routine for this!
Hi, if you just want to store the value of cost.amount into print.label do:
If you want to perform a calculation with both the print.label and cost.amount and you work with IDS 9.x or higher do an explicit cast, like:
UPDATE print SET label =
(SELECT amount FROM cost WHERE cost.key = print.key)
WHERE key = ...
SELECT cost.amount + print.label::smallint
FROM print, cost
Last edited by Tyveleyn; 11-09-07 at 18:56.