
```sql

SELECT chat.username, chat.innerText, chat.badge, chat.symbol, chat.date from chat

  -- WHERE LOWER(chat.innerText) ~ 'btc'
  WHERE LOWER(chat.in...

PostgreSQLでselect文を書くには


```sql

SELECT chat.username, chat.innerText, chat.badge, chat.symbol, chat.date from chat

  -- WHERE LOWER(chat.innerText) ~ 'btc'
  WHERE LOWER(chat.innerText) ~ 'double.?top|double.?bottom|head.?(and|&).?shoulders|divergence|flag|engulfing|triangle|wedge|pennant'
  AND ((chat.timestamp AT TIME ZONE 'UTC') AT TIME ZONE 'JST') > current_timestamp - interval '48 hours'
  order by id desc
  -- LIMIT 3

```