Hi
Sorry if this has been raised before but the following function will not
be reverse engineered correctly - It will be changed into a setof return
which will break anything expecting organisation_id.
CREATE OR REPLACE FUNCTION public.t() RETURNS TABLE (organisation_id
integer) AS
$$ select 27;
$$ LANGUAGE 'sql';
In pgAdmin 10.2 it becomes :-
CREATE OR REPLACE FUNCTION public.t() RETURNS SETOF integer AS
$BODY$ select 27;
$BODY$ LANGUAGE 'sql' VOLATILE COST 100 ROWS 1000;
Many thanks
Kieran