Top "Stored-functions" questions

Dynamic SELECT INTO in PL/pgSQL function

How can I write a dynamic SELECT INTO query inside a PL/pgSQL function in Postgres? Say I have a …

postgresql variable-assignment plpgsql dynamic-sql stored-functions

MySQL does not support recursive functions? why? since when?

I've written a stored FUNCTION that calls itself, recursively. However when I run it in a query I get this …

mysql stored-procedures recursion user-defined-functions stored-functions

Convert stored procedure to table-valued query

I have this procedure ALTER PROCEDURE [dbo].GetHerdByUserProc(@user int) As begin Declare @GroupId uniqueidentifier, @UserTrade bit Set @GroupId = (select …

sql sql-server-2008 stored-procedures stored-functions sql-function

Compute 2,3 quartile average in SQL

I want to write a stored proc in SQL (MySQL) to compute the average of second and third quartiles. In …

mysql sql stored-procedures stored-functions

Select statements included within a function cannot return data to a client_New

I've been reading about the error on the question title but I cannot figure out what is the error on …

sql-server tsql stored-functions

Npgsql pass parameters by name to a stored function

I'm working with code I'm converting to Pgsql working with .NET. I want to call a stored function that has …

c# npgsql stored-functions postgresql