wood burning stoves 2.0*
The moose likes JDBC and the fly likes creat a Stored Procedures in pgsql? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "creat a Stored Procedures in pgsql?" Watch "creat a Stored Procedures in pgsql?" New topic

creat a Stored Procedures in pgsql?

zknyy wolf

Joined: Jan 07, 2003
Posts: 21
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

Joined: Dec 10, 2001
Posts: 7023
What difficulty are you having exactly? Have you already figured out using JDBC to execute other statements?
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!

[How To Ask Good Questions] [JavaRanch FAQ Wiki] [JavaRanch Radio]
Consider Paul's rocket mass heater.
subject: creat a Stored Procedures in pgsql?
Similar Threads
Stored procedures in J2EE
what are procedures in sql ?
Can I execute Oracle procedures through satement
Stored Procedures
how to change the database?