Pivot Query in Postgresql
select * from
crosstab( $$
SELECT anonymous_id, message_id , timestamp, key, value
FROM pixels
WHERE tenant_id = 2
AND pixels.timestamp >= '2019-10-19 10:41:03.254968'
AND pixels.timestamp < '2019-10-20 10:41:03.254968'
AND message_id = ANY(SELECT message_id
FROM pixels
WHERE tenant_id = 2
AND pixels.timestamp >= '2019-10-19 10:41:03.254968'
AND pixels.timestamp < '2019-10-20 10:41:03.254968'
AND key = 'event'
AND value = 'init_banuba_success'
)
AND (key = ANY(array['context.timezone','context.device.model','context.device.os']))
$$,
$$
values ('context.timezone') ,
('context.device.model') ,
('context.device.os')
$$)
AS ( anonymous_id TEXT,
message_id TEXT,
timestamp timestamp,
context_device_model TEXT,
context_device_os TEXT,
context_timezone TEXT);
Harrah's Cherokee Casino & Hotel - MapYRO
ReplyDeleteHARRAH'S 군산 출장샵 CHEROKEE CASINO & HOTEL - 2021 Updated 777 Casino Drive Cherokee, 여주 출장마사지 NC 28719. Directions · (800) 정읍 출장샵 462-5000. 삼척 출장안마 Call Now · More Info. 광주광역 출장마사지 Hours, Accepts Credit Cards,
Os dramas e as emoções de AFazenda16 estão imperdíveis! Veja mais.
ReplyDelete