Postgres Pro
Downloads
Home   >   mailing lists

Re: syntax error on Function return setoff - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: syntax error on Function return setoff
Date
Msg-id E12A7004-3B79-48CB-93CF-2E085057CE12@a-kretschmer.de
Whole thread Raw
In response to syntax error on Function return setoff  (Garry Chen <gc92@cornell.edu>)
Responses Re: syntax error on Function return setoff
List pgsql-novice
Tree view 
On 26 January 2018 19:39:27 CET, Garry Chen <gc92@cornell.edu> wrote:
>Hi All,
>I have a working function that returns setoff record was created under
>porstgresql 9.6 but  when I try to create the same function under
>release 10 it gives me error type”recode” does not exist.  Therefore, I
>changed it to RETURNS SETOF table_name.column%varachar(7) I got syntax
>error.  Can anyone let me know the right syntax?
>
>Thank you very much,
>Garry


Maybe a typo? "recode" is wrong...

Can you show the function-definition?


Regards, Andreas


--
2ndQuadrant - The PostgreSQL Support Company

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: syntax error on Function return setoff
Next
From: Garry Chen
Date:
Subject: Re: syntax error on Function return setoff