Re: syntax error on Function return setoff

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-novice(at)lists(dot)postgresql(dot)org,Garry Chen <gc92(at)cornell(dot)edu>,"pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: syntax error on Function return setoff
Date: 2018-01-26 18:54:47
Message-ID: E12A7004-3B79-48CB-93CF-2E085057CE12@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 26 January 2018 19:39:27 CET, Garry Chen <gc92(at)cornell(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Garry Chen 2018-01-26 19:01:41 Re: syntax error on Function return setoff
Previous Message David G. Johnston 2018-01-26 18:52:13 Re: syntax error on Function return setoff