Re: raise is not working

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: raise is not working
Дата
Msg-id 27296.1095958327@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: raise is not working  ("CHRIS HOOVER" <CHRIS.HOOVER@companiongroup.com>)
Список pgsql-sql
"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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "CHRIS HOOVER"
Дата:
Сообщение: Re: raise is not working
Следующее
От: "CHRIS HOOVER"
Дата:
Сообщение: Re: raise is not working