column name does not exist

From: abhinav mehrotra <talk2abhinav(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: column name does not exist
Date: 2009-07-28 16:41:07
Message-ID: 9e157d6c0907280941r563545e9q7cfbb1f655560150@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

I have created a stored procedure

CREATE OR REPLACE FUNCTION ab(integer, integer,varchar,text,integer) RETURNS
text AS'
DECLARE
ret text;
BEGIN
if(ret is null) then
raise notice ''invalid auxiliary tag'';
end if;
return ret;
END;
'LANGUAGE 'plpgsql';

On doing: select * from ab (1,4,"exam","abhi",5);

I get an error : ERROR: column "exam" does not exist.

Any idea what is going wrong? Am I missing something?

Thanks in Advance
Abhinav

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Wood 2009-07-28 17:05:19 Re: column name does not exist
Previous Message Peter Jackson 2009-07-28 12:26:18 Re: Location of databases