Jan,
> I assume you're trying to do something like
>
> CREATE FUNCTION myfunc(mytab.x%TYPE, mytab.y%TYPE) ...
>
> because that's the only way I've found to get this error
That's correct.
> Indeed, a good idea (for 7.2). Bruce, put it onto TODO
> please.
T
Josh Berkus wrote:
> Folks,
>
> 1. While I am able to use the %TYPE declaration within
> PL/PGSQL functions, I am unable to use this declaration in
> the parameters for the function -- I get 'Parse Error at or
> near "."'
I assume you're trying to do something like
CREATE FUNCTION my
Folks,
1. While I am able to use the %TYPE declaration within
PL/PGSQL functions, I am unable to use this declaration in
the parameters for the function -- I get 'Parse Error at or
near "."'
2. When I have a PL/PGSQL function return a custom message
using a VARCHAR return value, I get backslashe
