Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE "price_index" AS "t"
- SET
- "average"="v"."average"::numeric,
- "weighted"="v"."weighted"::numeric,
- "trades_count"="v"."trades_count",
- "volume"="v"."volume"::numeric,
- "volume_quote"="v"."volume_quote"::numeric,
- "min"="v"."min"::numeric,
- "max"="v"."max"::numeric,
- "open"="v"."open"::numeric,
- "close"="v"."close"::numeric,
- "open_trade_time"="v"."open_trade_time"::timestamp,
- "close_trade_time"="v"."close_trade_time"::timestamp,
- "last_trade_id"="v"."last_trade_id",
- "updated_at"="v"."updated_at"::timestamp
- FROM
- (VALUES
- (28,'D1','2018-04-12T00:00:00.000+00:00','6053.940780000023','6112.952385581849',22000,'3218.856392500000','19676715.863378227600','5481.000000000000','6568.020000000000','5625.530000000000','6225.150000000000','2018-04-12T00:00:12.000+00:00','2018-04-12T12:35:53.000+00:00',30070784,'2018-04-23T09:13:56.068+00:00'))
- AS
- "v"(
- "price_index_config_id",
- "type",
- "time",
- "average",
- "weighted",
- "trades_count",
- "volume",
- "volume_quote",
- "min",
- "max","open","close","open_trade_time",
- "close_trade_time","last_trade_id","updated_at")
- WHERE
- t.price_index_config_id = v.price_index_config_id
- AND t.type = v.type
- AND t.time = v.time::timestamp;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement