Use stored-functions for questions related to database specific user-defined functions which can perform queries, accept parameters, and return a computed value.
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-functionWhat is the mechanism to force the MySQL to throw an error within the stored procedure? I have a procedure …
mysql stored-procedures throw stored-functionsI'm slowly moving from MSSQL to PostgreSQL. In MSSQL I could call editing of already saved procedure or function, and …
postgresql stored-procedures stored-functionsI'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-functionsI am trying to create a mysql stored procedure . I have successfully created a procedure using the following code : delimiter $$ …
mysql database stored-procedures stored-functionsI'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-functionsI'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-functionsI would like to use goto in MySQL stored function. How can I use? Sample code is: if (action = 'D') …
mysql goto stored-functionsMy 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-functionsI am having some difficulty getting a pretty simple stored procedure right. Consider the following article table snippet: id replaced_…
mysql loops stored-functions