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 по дате отправления: