I'm getting the below error for the given function. Msg 2010, Level 16, State 1, Procedure GetTableFromDelimitedValues, Line 2 Cannot perform alter on 'dbo.GetTableFromDelimitedValues' because it ...

Is it possible to extend an existing datatype in PostgreSQL? Essentially, I want the equivalent of this TypeScript but in SQL: interface Meeting { id: number; start: Date; end: Date; descriptio...

In the DOC only described how to change function definition. But I have only function body changed (text between $$ sql $$). How to replace only this function body? Should I use CREATE OR REPLACE...

When looking at PHP's create_function it says: If you are using PHP 5.3.0 or newer a native anonymous function should be used instead. I want to recreate same functionality of create_function...

I found following solution here on StackOverflow to get an array of a specific object property from array of objects: PHP - Extracting a property from an array of objects The proposed solution is ...

I have a simple MySQL function for comparing versions: CREATE FUNCTION `compareVersions` ( versionA VARCHAR(50), versionB VARCHAR(50)) RETURNS INT DETERMINISTIC NO SQL BEGIN DECLARE a1 INT; DE...

Given the schema CREATE TABLE users ( id bigserial PRIMARY KEY, email varchar(254) NOT NULL ); CREATE UNIQUE INDEX on users (lower(email)); CREATE FUNCTION all_users() RETURNS users AS $$ SELE...

First time I am trying to use the dynamic create_function, and up to now, not much success :-) My function is this : function o99_brsa_custom_widgets() { global $wp_meta_boxes; global $o99_brs...

I want to run the following mysql create function statement from PHP: DELIMITER $$ CREATE FUNCTION `myFunc`(`instring` varchar(4000)) RETURNS int(11) NO SQL DETERMINISTIC SQL SECURITY INVOKER B...

I have a function that I currently use in PHP which compiles a mailing address from separate fields but takes into account different formats used in different regions. I'm trying to replicate this ...

In PHP you have the create_function() function which creates a unique named lambda function like this: $myFunction = create_function('$foo', 'return $foo;'); $myFunction('bar'); //Returns bar Is...