Re: User-defined function with anyrange[]

2018-07-08 Thread Paul A Jungwirth
> you can use overloading to define > several functions of the same name, and just write out one for each > range type you actually need this functionality for. Thanks! I was hoping to avoid that, but it's what I wound up doing after all, as you can see here: https://github.com/pjungwir/range_agg

Re: User-defined function with anyrange[]

2018-07-06 Thread Tom Lane
Paul A Jungwirth writes: > I want to make an aggregate function range_agg(anyrange) that returns > anyrange[]. But when I try to define it, Postgres tells me it doesn't > know what an anyrange[] is. I get this error: Yeah, there is no such thing as anyrange[], nor arrays over any other pseudo-typ

User-defined function with anyrange[]

2018-07-05 Thread Paul A Jungwirth
Hello, I want to make an aggregate function range_agg(anyrange) that returns anyrange[]. But when I try to define it, Postgres tells me it doesn't know what an anyrange[] is. I get this error: ERROR: type anyrange[] does not exist I also tried taking an anyrange and returning an anyarray, which