"Tomasz Myrta" <[EMAIL PROTECTED]> wrote:
> Hi
> Do you have any easy script to remove all pl/pgsql function? After a lot
of
> changes inside "create or replace function..." scripts I have a big mess.
I
> want to remove all user defined pl/pgsql functions and restore some of
them
> from my scripts
"Yudie" <[EMAIL PROTECTED]> wrote:
> Hi,
> I',m trying to create trigger with plpgsql trigger function
> then I got this error message when trigger executed:
> Number: -2147467259
> Error while executing th query;
> ERROR: fmgr_info: function 1546856080: cache lookup failed
> Here is the function
From: "Mr Weinbach, Larry" <[EMAIL PROTECTED]>
> But at execution time I am getting thi error :
>
> WARNING: Error occurred while executing PL/pgSQL
> function word_case
> WARNING: line 5 at return next
> ERROR: Set-valued function called in context that
> cannot accept a set
>
> I also tried
I didn't read all the entire problem but try to use
WHERE instead of WHEN.
Regards
Gaetano Mendola
- Original Message -
From: "javier garcia - CEBAS" <[EMAIL PROTECTED]>
To: "pgsql-sqL" <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 12:55 PM
Subject: [SQL] EXTERN JOIN with WHEN query
