Re: raise is not working

"CHRIS HOOVER" <CHRIS.HOOVER@companiongroup.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, egSQL_Str := ''select * from clmhdr'';
See the docs.
        regards, tom lane