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
>
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
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
