| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "CHRIS HOOVER" <CHRIS(dot)HOOVER(at)companiongroup(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: raise is not working |
| Date: | 2004-09-23 17:11:46 |
| Message-ID: | 27523.1095959506@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"CHRIS HOOVER" <CHRIS(dot)HOOVER(at)companiongroup(dot)com> writes:
> They were a double quote. I switched all of the double quotes out for single
> quotes but still not go. The function appears to run and return no results
> but, I don't get any raises. I have even tried moving the raises to be fire
> first lines in the function, but to no avail.
Hmm. We saw a case just the other day where someone was mystified why
they weren't getting reasonable results, and it turned out that what
they were doing was editing function foo(something) and then invoking
a pre-existing function foo(somethingelse). Check for similarly-named
functions with different parameter lists ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karsten Hilbert | 2004-09-23 20:24:17 | need "row number" |
| Previous Message | CHRIS HOOVER | 2004-09-23 17:04:00 | Re: raise is not working |