Reputation
15,810
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
3 29 58
Newest
 Copy Editor
Impact
~1.0m people reached

Oct
20
comment Where to download (Dutch) Postgresql Fulltext Search dictionaries
You can use the hunspell dictionaries from the OpenOffice/LibreOffice project: hunspell.sourceforge.net
Oct
18
comment Postgres blocking UPDATE on new column?
As a general rule of thumb: just don't quote any identifiers.
Oct
17
comment Why is MySQL Server software so huge?
You only think it's huge until you download Oracle: that's approx. 4.5 GB
Oct
17
comment Join 3 tables and return only distinct values for max datetime
@DeLL It seems you are using a DB2 version that does not support window function. I though all DB2 versions - including the host based ones - support this (it is definitely valid for DB2 LUW)
Oct
17
comment Join 3 tables and return only distinct values for max datetime
@ypercube: the condition WHERE A.TRANNO=(SELECT MAX(TRANNO) FROM tableA A where A.CASENO=B.CASENO) implies partition by a.caseno to me.
Oct
17
comment Join 3 tables and return only distinct values for max datetime
"where a.date between 140124 and 140331" - are you really storing dates as integers like that? And why do you split the date and the time into two different (integer) columns? It will be much better to use a proper timestamp column instead.
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
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
comment PostgreSQL return second 'Group' as an array
@ClaesMogren: good point, fixed.
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
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
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 Oracle Concurrent Insertion
Session2 will not hang. Why don't you just try for yourself? This is really easy to test
Oct
15
comment postgresql replace table without losing dependancies
I have never seen a create or replace table in any other DBMS (Oracle, SQL Server, DB2, Firebird, HSQLDB, ....)
Oct
15
comment postgresql replace table without losing dependancies
What's wrong with using ALTER TABLE?
Oct
14
comment Using if statement outside of a stored procedure or function
"Are if statements usable outside stored procedures?" - no
Oct
13
comment work with json in oracle
@drew: I know. This was intended to make Lloyd aware of the subtle difference between .0.2 and .0.1