Function pipelines: Building functional programming into PostgreSQL

Re:Function pipelines: Building functional programming into ... by akulkarni on Tuesday October 19, 2021 @12:23PM (#28919960)

Also, the team picked `->` as the operator, which I thought was a very natural and intuitive choice :-)

e.g.,

  SELECT device_id, timevector(ts, val) -> sort() -> delta() -> abs() -> sum() as volatility

[ Parent | on HN ]

Re:Function pipelines: Building functional programming into ... by OJFord on Tuesday October 19, 2021 @12:32PM (#28920066)

What if those functions (were something that) returned json{,b}?

Oh or I see timevector returns a custom datatype, so I suppose the answer is it has to be one of a fixed number of provided types?

[ Parent | on HN ]

Re:Function pipelines: Building functional programming into ... by Lockerman on Tuesday October 19, 2021 @12:45PM (#28920229)

> Oh or I see timevector returns a custom datatype, so I suppose the answer is it has to be one of a fixed number of provided types?

Exactly! These aren't general arithmetic operators, they're specifically for mapping arithmetic operations over timevectors.

[ Parent | on HN ]

Re:Function pipelines: Building functional programming into ... by djk447 on Tuesday October 19, 2021 @12:45PM (#28920227)

(NB: post author here)

We're planning on providing various outputs, json is definitely one format we'd want to support, want to file a github issue with the layout that you'd want and we can start getting some feedback to implement?

[ Parent | on HN ]