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/ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
