Re: Wierd issue with printf and DBD::Pg

Use sprintf instead of printf. -- Peter Vanroose. On 1 october 2018 12:13 Mike Martin <> wrote: > If I use printf to round a numeric value before inserting into postgres table > it is altered to 1 rather than the value when it is put into a table > > example > > CREATE TABLE public.chksize >

Re: Wierd issue with printf and DBD::Pg

On Monday 01 October 2018 11:13:48 Mike Martin wrote: > HI > If I use printf to round a numeric value before inserting into postgres > table it is altered to 1 rather than the value when it is put into a table Hi! Function printf takes format string with parameters and then it prints to the standa

Wierd issue with printf and DBD::Pg

HI If I use printf to round a numeric value before inserting into postgres table it is altered to 1 rather than the value when it is put into a table example CREATE TABLE public.chksize ( size numeric(10,2), #does not matter what field type path1 character varying COLLATE pg_catalog."defau