Abelisto's user avatar
Abelisto's user avatar
Abelisto's user avatar
Abelisto
  • Member for 8 years, 1 month
  • Last seen more than a month ago
  • Ukraine
12 votes

Why isn't this PosgreSQL LIKE query working?

9 votes
Accepted

Prevent DROP COLUMN in PostgreSQL

9 votes
Accepted

how to dump a case-sensitive table within a specific schema

9 votes
Accepted

Accumulate values into an array with Postgres

7 votes

How to make DISTINCT ON faster in PostgreSQL?

7 votes

pl/pgsql: Dynamicly get a column name from a record

6 votes
Accepted

pgsql - Delete data from huge table where not in

6 votes

How to generate a 1, 2, 3, 3, 2, 1, 1, 2, 3, 3, 2, 1, ... series in standard SQL or T-SQL?

6 votes
Accepted

INSERT INTO table FROM SELECT * with nextval() specification

5 votes
Accepted

Finding what the source of a specific PostgreSQL configuration setting

5 votes

How do I disable escaping when using COPY FROM in PostgreSQL?

4 votes

Building where clause based upon parameters

4 votes

Reverse Byte-Order of a postgres bytea field

3 votes

Convert character varying(255)[] to JSONB

3 votes
Accepted

Select distinct multiple columns with one result column

3 votes
Accepted

Postgresql cant declare cursor

3 votes
Accepted

Function returning table : access individual fields

3 votes

UPDATE with LIMIT / OFFSET in PL/pgSQL function

2 votes

Nested aggregate functions over different dimensions

2 votes

Identify columns that allow NULL but don't contain NULL

2 votes
Accepted

Adding id column of table to a hstore column postgres

1 vote

Create a trigger on all the last_modified columns in PostgreSQL

1 vote
Accepted

PostgreSQL 9.5: Permission to deny functions body

1 vote
Accepted

Group permissions in postgreSQL not inheriting to table level

1 vote
Accepted

Aggregate count over variable number of json keys

1 vote
Accepted

Fastest query for selecting arrays that contain duplicates

1 vote

Pivot time series into date period columns with array aggregate cells

1 vote

Compare words in a string without considering their positions?

1 vote
Accepted

How to unify aggregating function with Postgres per different group by

1 vote
Accepted

Unable to join on conrelid and confrelid columns in pg_constraint