27,437 reputation
24279
bio website
location Vienna, Austria
age 95
visits member for 3 years, 6 months
seen 12 hours ago

Freelance database expert.


12h
revised Best way to drop / recreate a table that has dependent views?
added 9 characters in body
14h
answered Best way to drop / recreate a table that has dependent views?
1d
revised Sampling in PostgreSQL
added 673 characters in body
1d
revised Sampling in PostgreSQL
format, add tag
1d
answered Sampling in PostgreSQL
2d
comment Query that was working on MySQL is not working on PostgreSQL
@timpone: This seems to be a misunderstanding. character varying(255) is the same as varchar(n) not character(n). And varchar is just fine (except hat the modifier 255 is typically based on another misunderstanding) and cannot explain the problem. Read the manual and check for NULL values ...
2d
comment Reference column alias in same SELECT list
@ŁukaszKastelik: Yes, that should be mentioned. In ORDER BY and GROUP BY, but not in WHERE or HAVING. Details here and here.
2d
revised Query that was working on MySQL is not working on PostgreSQL
clean up
2d
revised Prioritised table query
trim noise, add tag
2d
comment Prioritised table query
Your question is very vague and can be interpreted in many ways. Please be precise, and show a conclusive example. Also, always provide your version of Postgres.
2d
revised Query that was working on MySQL is not working on PostgreSQL
or NULL
2d
revised Reference column alias in same SELECT list
clean up, better title
2d
answered Reference column alias in same SELECT list
2d
comment Query that was working on MySQL is not working on PostgreSQL
You may be on the right track, let's try the opposite direction ...
2d
revised Query that was working on MySQL is not working on PostgreSQL
clean up, add tag
2d
answered Query that was working on MySQL is not working on PostgreSQL
Mar
30
comment Query that was working on MySQL is not working on PostgreSQL
Please provide proper information: "string" is not a data type. It should be obvious to provide the actual data type. And your version of Postgres.
Mar
29
revised Postgres: check disk space taken by materialized view?
add tags
Mar
29
answered Postgres: check disk space taken by materialized view?
Mar
28
awarded  index-tuning