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

Oct
16
comment PostgreSQL return second 'Group' as an array
@DaveB: you are right. I forgot that.
Oct
16
comment Postgres top-k with ties
@Alexandros: sorry, I have no idea what you mean. Can you add more sample data to your question?
Oct
16
reviewed Reviewed Separate data from 1 column into multiple columns
Oct
16
revised Separate data from 1 column into multiple columns
added 30 characters in body
Oct
16
comment Rows are not getting deleted from MySQL Table
Does the "federated" storage engine support transactions? Maybe you are simply missing a commit?
Oct
16
awarded  Cleanup
Oct
16
comment PostgreSQL return second 'Group' as an array
@ClaesMogren: good point, fixed.
Oct
16
revised PostgreSQL return second 'Group' as an array
added 3 characters in body
Oct
16
revised PostgreSQL return second 'Group' as an array
rolled back to a previous revision
Oct
16
revised HTML Form: Insert id into related table
edited tags
Oct
16
comment Where does mysql store data?
@Konrad: that's actually pretty common. Oracle and SQL Server also store everything in a single file (although you can configure them differently)
Oct
16
comment Self Join? Or am I wrong?
I think this is because MINUS was introduced in Oracle long before this was defined in the SQL standard.
Oct
16
comment Self Join? Or am I wrong?
minus is Oracle specific. The SQL standard defines except
Oct
16
answered PostgreSQL return second 'Group' as an array
Oct
16
comment Postgres top-k with ties
@Alexandros: see my edit. By doing this in two "steps", this *could*(!) be faster. But you will have to check the execution plan with your real life data.
Oct
16
revised Postgres top-k with ties
added 80 characters in body
Oct
16
revised Postgres top-k with ties
added 80 characters in body
Oct
16
answered Postgres top-k with ties
Oct
16
comment Creating a rule increases load disproportionally
How do the involved tables look like? How does the rule look like? What are the statements that fire the rule? How big (=number of rows) are the tables? Which indexes are defined on the tables?
Oct
16
comment Find the sid of suppliers who supply every red part
Which DBMS are you using? Postgres? Oracle?