Question : I have a relational table where I need to loop through and sum amount values until a specified […]
Tag: functions
How to pass a table type with an array field to a function in postgresql
Question : i have a table called book CREATE TABLE book ( id smallint NOT NULL DEFAULT 0, bname text, […]
Using LOCATE() Function as SUBSTRING() parameter gives ramdom result. Extracting string from text
Question : I have several rows with a lot of content and i’m trying to find some code and extract […]
Split two delimited strings in same order without function
Question : I am trying to split two columns with delimited strings into rows. The positions of the values in […]
Why would call to scalar function inside a Table Value Function be slower than outside the TVF?
Question : I am writing a Table Value Function, calling the function takes 10x as long as directly running the […]
Postgresql Function Trying to Insert into 1 row instead of 2
Question : Postgresql 9.3, Mac OS X 10.6.7 I created this function and I would like to insert both results […]
Permissions needed for dbms_metadata.get_ddl in a function
Question : Oracle Enterprise 11.2.0.3 I’m receiving: ORA-31603: object “string of type “string” not found in schema “string” when executing […]
How to make PostreSQL functions private (inaccessible to end users)?
Question : When writing a set of PostgreSQL functions with procedural languages, is it possible to make some of the […]
Usage of aggregate function with when self-joining a table
Question : I want to find people from a database who has a weight bigger then the average weight: SELECT […]
Filter rows using a probabilistic filter (bloom filter or cuckoo filter) in Postgres
Question : I have a large table (~1B rows) with a btree index on a single bytea column (~20GB, but […]