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