Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group