[GENERAL] Set returning aggregate?

owing... value | count + 1 | 12 + 2 | 12 + 3 | 12 Is it possible for an aggregate function to return a set? I've written some test cases and it looks like the answer is No but I'd like confirmation. Thanks, Bborie Park P

[GENERAL] Elegant method of accessing N-dimension array in C function

receives a double precision[][] that is processed upon in my C function. Thanks! -bborie -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

[GENERAL] Determine a function's volatility in C

Hey all, I'm wondering if there is a way to determine a function's volatility in C. The function information provided through fmgr_info() doesn't provide it. Ideas? Thanks, Bborie -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.ed

[GENERAL] Passing NULL to a function called with OidFunctionCall3

} } datum = OidFunctionCall3(fcnoid, fcnarg[0], fcnarg[1], fcnuserarg); }}} The above does not work (segfault). What is the correct way to pass a NULL to the function being called? Thanks, Bborie -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu -- Se

Re: [GENERAL] Passing NULL to a function called with OidFunctionCall3

On 11/10/2011 04:43 PM, Tom Lane wrote: Bborie Park writes: I'm trying to make use of OidFunctionCall3 and am wondering how to resolve an issue. I need to be able to pass to the function called with OidFunctionCall3 a NULL and am having difficulty figuring out how. You can'

[GENERAL] Passing NULL to a function called with OidFunctionCall3

} } datum = OidFunctionCall3(fcnoid, fcnarg[0], fcnarg[1], fcnuserarg); }}} The above does not work (segfault). What is the correct way to pass a NULL to the function being called? Should I be using a different function other than OidFunctionCall3? Thanks, Bborie -- Bborie Park Programmer Center

Re: [GENERAL] Returning NULL to a set returning C type function

gards, tom lane Thanks Tom. I'll go the "no return any row" route. -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] Returning NULL to a set returning C type function

_histogram); Datum RASTER_histogram(PG_FUNCTION_ARGS) { -- if any of the args are incorrect, return NULL PG_RETURN_NULL(); } Thanks, Bborie -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu -- Sent via pgsql-general mailing list (pg