Re: RAISE EXCEPTION not working

On Thu, 20 Nov 2003, Brian H Mayo wrote:

> I am trying the use the following statements in a function:
>             SELECT INTO temp_i id FROM public.t_customer_profile WHERE
>                                     id=cust_id;
>                   IF NOT FOUND THEN
>                         RAISE EXCEPTION "Username already exists";
I think you want:
RAISE EXCEPTION ''Username already exists'';
(quoted text literals in SQL use single quotes, since it's in a quoted
function body, you'll need to use two single quotes).