Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

creat a Stored Procedures in pgsql?

 
zknyy wolf
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to creat a Stored Procedures in pgsql,but I only do as :
CREATE FUNCTION out() RETURNS varchar AS 'select no from testcode where id = 111' LANGUAGE 'sql';
Now I want to change "111" to a variable parameter
someone can help me!!
 
Dirk Schreckmann
Sheriff
Posts: 7023
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What difficulty are you having exactly? Have you already figured out using JDBC to execute other statements?
Also...
We ain't got many rules 'round these parts, but we do got one. Please change your display name to comply with The JavaRanch Naming Policy.
Thanks Pardner! Hope to see you 'round the Ranch!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic