Another problem with reverse engineering functions

Поиск
Список
Период
Сортировка
От Kieran McCusker
Тема Another problem with reverse engineering functions
Дата
Msg-id 4BBC4697.3060307@kwest.info
обсуждение исходный текст
Ответы Re: Another problem with reverse engineering functions  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
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






В списке pgadmin-support по дате отправления:

Предыдущее
От: "Garbin, David"
Дата:
Сообщение: GSSAPI Support under OSX
Следующее
От: Olivier Bouiron
Дата:
Сообщение: pgpass