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).