Abelisto

Abelisto has asked 17 questions and find answers to 53 problems.

Stats

About

Do not make things more complicated than they really are.

Abelisto questions

Format strings with fixed width (unicode and utf8)
Window running function except current row
PostgreSQL `analyse` vs `analyze`
PostgreSQL Upsert differentiate inserted and updated rows using system columns XMIN, XMAX and others

Abelisto answers

select all columns from both tables postgresql function
PostgreSQL - Extract value out of an array with position
Alias for a complete SQL statement? (in PostgreSQL psql)
UNNEST a composite array into rows and columns in Postgres
PostgreSQL inserting list of objects into a stored procedure
Using regexp_replace on array column in postgres
How to set timestamp(0) as default instead of timestamp(6) in PostgreSQL?
postgresql search text into array of text
Get created table name
Postgres aggregate alias for group_concat using string_agg