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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi All,

I have created a stored procedure

CREATE OR REPLACE FUNCTION ab(integer, integer,varchar,text,integer) RETURNS
text AS'
 ret text;
     if(ret is null) then
          raise notice ''invalid auxiliary tag'';
     end if;
     return ret;
'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


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-2017 The PostgreSQL Global Development Group