Top "Stored-functions" questions

Use stored-functions for questions related to database specific user-defined functions which can perform queries, accept parameters, and return a computed value.

MySQL stored function with nested IF... END IF, error in syntax, right syntax to use near ''

I have a function that I currently use in PHP which compiles a mailing address from separate fields but takes …

mysql mysql-error-1064 stored-functions create-function
How to throw an error in MySql procedure?

What is the mechanism to force the MySQL to throw an error within the stored procedure? I have a procedure …

mysql stored-procedures throw stored-functions
How to edit PostgreSQL stored procedure?

I'm slowly moving from MSSQL to PostgreSQL. In MSSQL I could call editing of already saved procedure or function, and …

postgresql stored-procedures stored-functions
How to use Table output from stored MYSQL Procedure

I've been looking for the last hour or so and haven't found a conclusive answer to this seemingly simple problem: …

mysql select stored-procedures stored-functions
Stored procedure does not exist, even after creating it

I am trying to create a mysql stored procedure . I have successfully created a procedure using the following code : delimiter $$ …

mysql database stored-procedures stored-functions
MySql calling stored function from within a stored procedure causing error

I'm getting a 1064 error when trying to call a stored function from within a stored procedure. It only happens on …

sql mysql stored-procedures mysql-error-1064 stored-functions
Recursive stored functions in MySQL

I'm trying to make a function that recursively builds a path for a specific category CREATE FUNCTION getPath(inId INT) …

sql mysql recursion recursive-query stored-functions
How to use goto label in MySQL stored function

I would like to use goto in MySQL stored function. How can I use? Sample code is: if (action = 'D') …

mysql goto stored-functions
Execute stored procedure with parameters postgresql

My Npgsql version 3.2.5 - Postgresql 9.6 I get this error with CommandType.StoredProcedure (but CommandType.Text works): Npgsql.PostgresException: '42883: function …

c# postgresql npgsql stored-functions
How to properly loop in a stored function on MySQL?

I am having some difficulty getting a pretty simple stored procedure right. Consider the following article table snippet: id replaced_…

mysql loops stored-functions