Re: raise is not working

"CHRIS HOOVER" <CHRIS(dot)HOOVER(at)companiongroup(dot)com> writes:
> Sorry for the delay, here is the function.

> CREATE OR REPLACE FUNCTION "public"."clmhdr_grid_query" (varchar, varchar,
> varchar, varchar, varchar, varchar) RETURNS SETOF "public"."clmhdr" AS'
> ...
> SQL_Str := "select * from clmhdr";

If those are really double quotes then I'd expect you to be getting
errors along the lines of

ERROR: column "select * from clmhdr" does not exist

long before you get to the RAISEs. You need doubled single quotes, eg
SQL_Str := ''select * from clmhdr'';
See the docs.

regards, tom lane