pathetic piss kitten (@kitten)

pathetic piss kitten @kitten@elizabeth.cat

1y

hold this

(SELECT to_timestamp("timestamp") as time, value FROM elizabeth.heart_rate_events
WHERE value > 0 and "timestamp" > (extract(epoch from now()) - 300) and value = (SELECT max(value) FROM elizabeth.heart_rate_events
WHERE value > 0 and "timestamp" > (extract(epoch from now()) - 300))
order by timestamp desc
limit 1) union (SELECT to_timestamp("timestamp") as time, value FROM elizabeth.heart_rate_events
WHERE value > 0 and "timestamp" > (extract(epoch from now()) - 300) and value = (SELECT min(value) FROM elizabeth.heart_rate_events
WHERE value > 0 and "timestamp" > (extract(epoch from now()) - 300))
order by timestamp desc
limit 1)

1🥴1

2

1

6

2

4 "back to setting fires" censord

@4censord@unfug.social

1y

@kitten :/

ERROR: relation "elizabeth.heart_rate_events" does not exist
LINE 2: ...ECT to_timestamp("timestamp") as time, value FROM elizabeth....

also its missing a ;

1

0

Lis (≙) retired account @lis@luisa.is

1y

@kitten no.
dumps this as well as your database

1

2

0

1