Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with postgresql
Search options not deleted
user 121320
All versions of PostgreSQL. Add an additional version-specific tag like [postgresql-13] if that context is relevant.
2
votes
2
answers
666
views
Insert result of a parallellized select query into a table, in Postgresql
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? …
- 175
2
votes
2
answers
2k
views
How to get lexemes in original sort order from ts_vector?
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 …
- 175
1
vote
2
answers
4k
views
Recommended Postgresql index type to be used with not equal (<>) where condition
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 …
- 175
1
vote
Postgresql function equivalent to Excel's NORMSINV function?
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 …
- 175
0
votes
0
answers
335
views
How to prevent regular users to backup database, in Postgresql
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 …
- 175
0
votes
How to get lexemes in original sort order from ts_vector?
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 …
- 175
0
votes
1
answer
387
views
Postgresql function equivalent to Excel's NORMSINV function?
I need Excel's NORMSINV equivalent function for PostgreSQL, preferably plpgsql function. Can somebody help? …
- 175