Password reset
Cancel
Sign up for free
JT wrote: 🕐 03-11-26 15:28If you are upgrading postgres from 9.x to a newer version, some changes to aggregate functions have been m,ade. Therefore, to identify existing custom aggregate functions, run this sql
SELECT n.nspname as schema_name, p.proname as aggregate_name, pg_catalog.format_type(p.prorettype, NULL) as return_type, p.prosrc as function_source, obj_description(p.oid, 'pg_proc') as description
FROM pg_proc p
JOIN pg_namespace n ON n.oid = p.pronamespace
JOIN pg_aggregate a ON a.aggfnoid = p.oid
WHERE n.nspname NOT IN ('pg_catalog', 'information_schema')
ORDER BY schema_name, aggregate_name;
Simply send us an email to support@postgressolutions.com with details of howmany attendees, what type of training and we will get back to you.
JT
How to attend this training class? is there any link to subscribe or attend? what is the deatils regarding this training? Please can someone updates? Thanks