Question : I have a setup program that requires plpgsql to install stored procedures in a PostgreSQL 8.4 database. I […]
Tag: functions
How to Set the Transaction Isolation level in a Table Value Multi Function
Question : How do I set the transaction isolation level within in a table value multi function? I know it […]
Explain doesn’t show indexed column as key
Question : Consider the following table structure CREATE TABLE `games` ( `game_id` bigint(20) NOT NULL AUTO_INCREMENT, `players_no` tinyint(4) DEFAULT NULL, […]
Is GROUP BY select-list-ref less optimized than GROUP BY colname?
Question : Just wondering if GROUP BY 1 is slower than GROUP BY col? SELECT x, count(x) FROM foo GROUP […]
Encoding issue mysql
Question : I’m using the MD5 hash function of MySQL to hash some data I import into the database from […]
I’m trying to make an SQL injection in my own function in PostgreSQL 13
Question : Just for learning purposes, I’m trying to create a function using PLPGSQL and make an SQL injection on […]
RETURN value directly from INSERT with RETURNING clause
Question : I have a function that ends with: INSERT INTO configuration_dates ( cols… ) VALUES ( values… ) RETURNING […]
Trigger function error: Record “old” not yet assigned
Question : I’m new to trigger functions and trying to work this out. I have looked for solutions in the […]
How to create function(table_name) that returns a set of the table
Question : I have a set of tables that share the same fields (some timestamps and users names used for […]
Automatic conversion of anonymous records returned from an UDF to well known table-type
Question : Proprietary code (that we cannot change) has a bunch of user defined functions of the type: create or […]