Functions that return RECORD type

Поиск
Список
Период
Сортировка
От Craig Bryden
Тема Functions that return RECORD type
Дата
Msg-id 00a001c4f9a8$97cf8c80$77d417c4@amd2800
обсуждение исходный текст
Ответы Re: Functions that return RECORD type
Список pgsql-general
Hi

I come from a MS-SQL background and am trying to figure out what is wrong
with the function below:
****************************************************************************
*************
CREATE OR REPLACE FUNCTION GetAccountInfo (p_AccID int)
RETURNS record
AS
$$
DECLARE
 r_Return record;
BEGIN
 SELECT a.Field1, a.Field2, a.Field4
 INTO r_Return
 FROM Account
 WHERE a.AccID = p_AccID;

 RETURN r_Return;
END;
$$
language 'plpgsql';
****************************************************************************
*************
When I run     select * from GetAccountInfo (100)    I get the following
error message: ERROR:  a column definition list is required for functions
returning "record"

please can someone explain to me how to create a column definition list.


Thanks


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: allowing connections from additional hosts without a restart?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: allowing connections from additional hosts without a restart?