创建 JSON 对象时，数字的显示方式会有所不同

问：

我有以下功能：

CREATE OR REPLACE FUNCTION aggregate_view(ticker text, from_time timestamp)
RETURNS TABLE (data text)
LANGUAGE sql AS
$func$
SELECT
    json_build_object(
        'candles',
        (SELECT json_agg(array [EXTRACT(EPOCH FROM ts_bucket), "open", high, low, "close", volume :: BIGINT]) AS json_array_of_arrays
        FROM exchange.candles_d1
        WHERE exchange.candles_d1.ticker = $1 AND candles_d1.ts_bucket >= $2 AND candles_d1.ts_bucket < $2 + INTERVAL '1 hour'),

        'kvwap',
        (SELECT json_agg(array [EXTRACT(EPOCH FROM ts_bucket), m1, m5, m15, m30, h1, h2, h4, d1, low, vwap, high]) AS json_array_of_arrays
        FROM exchange.kvwap_d1
        WHERE exchange.kvwap_d1.ticker = $1 AND kvwap_d1.ts_bucket >= $2 AND kvwap_d1.ts_bucket < $2 + INTERVAL '1 hour'),

        'zones',
        (SELECT json_agg(array[EXTRACT(EPOCH FROM ts_confirmation)::BIGINT, EXTRACT(EPOCH FROM ts_end)::BIGINT, confirmations, CAST(is_continuation AS INT)])
        AS json_array_of_array
        FROM analysis.zones
        WHERE analysis.zones.ticker = $1 AND "interval" = 'D1' AND ts_confirmation >= $2 AND ts_confirmation < $2+ INTERVAL '1 hour')
    )
$func$;

时间戳存储为 （time - EPOCH），但在输出 json 中，格式因表而异。每个块中的第一个值是时间戳：

 {
   "candles":[
      [
         1577836800,
         7189.43,
         7260.43,
         7170.15,
         7197.57,
         409678761
      ]
   ],
   "kvwap":[
      [
         1.5778368e+09,
         7213.8125,
         7213.5947,
         7212.4907,
         7210.914,
         7209.1133,
         7207.789,
         7207.2,
         7206.961,
         7170.15,
         7213.8574,
         7260.43
      ]
   ],
   "zones":null
}

请注意，一个时间戳写成 1577836800，而另一个写成 1.5778368e+09，这是相同的数字。

为什么？以及如何防止数字以科学记数法显示？