Postgres Pro
Downloads
Home   >   mailing lists

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

From Garry Chen
Subject syntax error on Function return setoff
Date
Msg-id 00041073-0ADB-47DB-969B-B2CC8C50B3A6@cornell.edu
Whole thread Raw
Responses Re: syntax error on Function return setoff
Re: syntax error on Function return setoff
List pgsql-novice
Tree view

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

pgsql-novice by date:

Previous
From: "ferraresso@tin.it"
Date:
Subject: R: Re: R: Re: create subscription, connection string, password inlog not hide
Next
From: "David G. Johnston"
Date:
Subject: Re: syntax error on Function return setoff