Re: a column definition list is required for functions returning "record" - Mailing list pgsql-general

Alexander Farber <alexander.farber@gmail.com> writes:
> in 9.5.3 I have defined the following custom function:

> CREATE OR REPLACE FUNCTION words_select_games(IN in_uid integer)
>         RETURNS SETOF RECORD AS

> I have also unsuccessfully tried
>         RETURNS SETOF words_games, words_moves AS

> How would you recommend to fix my declaration problem please?

I think you are looking for the RETURNS TABLE syntax.

            regards, tom lane