search

risingwavelabs / risingwave

Best-in-class stream processing, analytics, and management. Perform continuous analytics, or build event-driven applications, real-time ETL pipelines, and feature stores in minutes. Unified streaming and batch. PostgreSQL compatible.
https://go.risingwave.com/slack
Apache License 2.0
7.06k stars 580 forks source link

Feat: week interval unit #10669

Open st1page opened 1 year ago

st1page commented 1 year ago

PG: 

psql (15.3)
Type "help" for help.

pg=# select INTERVAL '1 week';
 interval 
----------
 7 days
(1 row)

RW:

psql (15.3, server 8.3.0)
WARNING: psql major version 15, server major version 8.3.
         Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.

dev=> select INTERVAL '1 week';
ERROR:  QueryError: Bind error: failed to bind expression: INTERVAL '1 week'

Caused by:
  Invalid input syntax: unknown unit week
yuhao-su commented 7 months ago

'1 week' is all over our docs. We might want to either finish this or change our doc