12,179 reputation
11947
bio website
location Munich
age
visits member for 3 years, 5 months
seen 19 mins ago

3h
revised PostgreSQL procedural languages overhead (plpython / plsql / pllua…)
edited body
7h
comment Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
the over (partition by...) thing is called a "window function".
7h
revised Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
edited tags
21h
revised ORA-01410 Error
added 44 characters in body; edited tags
21h
comment Get seconds of day in Postgres
@ErwinBrandstetter: nice trick, I didn't think of using epoch on only the time part ;)
1d
revised Get seconds of day in Postgres
added 326 characters in body
1d
comment Get seconds of day in Postgres
@TimoteoPonce: sorry I didn't see that. There is no direct function to do that. You need to extract seconds, minutes and hours individually. But of course you can put that into a function.
1d
comment Why does this query take 32 sec to execute?
Unrelated but: why are you using having when you are not using group by?
1d
answered Get seconds of day in Postgres
1d
revised Postgresql single base on multiple HDD partitions
added 13 characters in body
1d
revised Meaning of 'show variables LIKE '%_database'
added 58 characters in body
1d
comment How to import large sql file in postgres?
Postgres is the (backend) server, psql is the client tool. The exception can either happen on the client when reading the file, or on the backend which is executing the individual SQL statements.
1d
comment How to import large sql file in postgres?
Is psql throwing the out of memory error, or is the backend server that has the problem?
1d
comment Size of Postgres database growing
Have a look at Postgres-XL
1d
revised WITH Clause UNION Issue
edited tags
2d
revised How to run specific version (8.4, 9.1) of postgresql pg_* command (e.g., pg_dump)
edited tags
2d
comment Combine 3 tables
wiki.postgresql.org/wiki/SlowQueryQuestions
2d
reviewed Close Migrate database from server old to new server with centos
2d
comment numbering distinct column values in an ordering but not just displaying the total
There is no DBMS named "Visual 8.0"
Oct
22
comment numbering distinct column values in an ordering but not just displaying the total
Which DBMS are you using? Postgres? Oracle?