Search Results

This function seems to work, Please, suggest if there is a better way. CREATE OR REPLACE FUNCTION public.tokenize_orig( p_string text, p_dictionary regconfig) RETURNS text[] AS $BODY$ /* T …

Postgres' full text search to_tsvector() function returns a sorted array of lexemes. I need exactly that, just with lexemes in original sort order. Is there any such Postgres function, or do I need to …

How can I prevent/restrict regular users, that do have select rights granted on tables etc, to perform backup of Postgres database? Is there a way to enable users to connect, select, update etc. tabl …

I need Excel's NORMSINV equivalent function for PostgreSQL, preferably plpgsql function. Can somebody help? …

This is debugged David Fetter's function: CREATE OR REPLACE FUNCTION public.normsinv(prob double precision) RETURNS double precision LANGUAGE sql COST 100 IMMUTABLE STRICT PARALLEL SAFE AS $BODY …

My question is: Is there any way to trick the Postgresql so that a SELECT query is executed as parallel query and then its result inserted into a table? …

I need to query two huge tables (more than milion records). Besides other conditions, there is also a not equal (<>) where condition on a columns pair of varchar type. It has to exclude one in a milli …