Hello All,
I want to store count(*) of a table in a variable ,
for that I have declared a variable and wrote a
statment but it is giving me error.
can anybody please help me..
CREATE OR REPLACE FUNCTION foreign_keys_tables(OUT
par_result charecter varying, IN par_tablename
character varying , IN par_clomnname,IN par_colvalue
integer) AS
$BODY$)
DECALRE
countno integer;
BEGIN
Select count(*) into countno from par_tablename where
par_columnname=par_colvalue;
if countno>0 then
par_result='yes'
else
par_result='No'
end if
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
it is giving me error in select statment,
Thanks in advance
With Regards
Ashish Karalkar
____________________________________________________________________________________
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives.
http://tools.search.yahoo.com/toolbar/features/mail/