7,004 reputation
31640
bio website
location Berlin, Germany
age 39
visits member for 2 years, 10 months
seen 4 hours ago

Feb
25
comment Is it possible to pipe the result of a mysqldump straight to rsync as the source argument?
Have you already tried it? :)
Feb
25
comment How and what is the most efficient way to join two tables, retaining a particular field from both?
Is Component1 present in both tables? If yes, how do you identify it in each table? If no, how do you get data3 and data4 for Component1?
Feb
23
comment Why is a new user allowed to create a table?
Regarding the error, it can be easily reproduced by issuing the commands from the question and your REVOKE in order :)
Feb
23
comment Why shouldn't we allow NULLs?
I have NULLs in my database and I still can build nice and performant reports on top of it... At the same time, I don't see how a NULL would cause 'more load on Engine'.
Feb
22
comment Unit testing of stored procedures
Firstly, thank you for your answer - I didn't expect any further advancement on this question... Secondly, I have to admit that you are right about the simple operations: even a two-column INSERT can produce a bug. If it is written so that the column order can be matched against the arguments then it may be OK, but then you are right, again: it is probably better keeping the whole app under the testing regime.
Feb
21
comment How can FLOOR(3) equal 2?
@Andomar have you read the question? How would you calculate the number of digits of 999 with round()?
Feb
21
comment How can FLOOR(3) equal 2?
Illustration and a possible solution: sqlfiddle.com/#!6/d41d8/2739
Feb
21
comment Does PostgreSQL optimize queries in transaction?
There is no such optimization (to my knowledge there is no RDBMS that can do this). So you'll have to roll your own solution.
Feb
21
comment Does MYSQL join before LIMIT?
Let me add that in the case of a JOIN, it must be performed first to get the output rows to be sorted.
Feb
21
comment Does MYSQL join before LIMIT?
@Ata the check is this simple: sqlfiddle.com/#!2/96b0c7/2 There is clearly no sign of user2 or user3 in the output, which means that the JOIN is performed first.
Feb
21
comment Does MYSQL join before LIMIT?
@RolandoMySQLDBA I think you answered perfectly (dropped a +1). My problem is that the normal order of joins and LIMIT can be checked very easily. (Of course, you are right, without knowing the actual query we can't tell whether there is an easy solution or not.)
Feb
21
comment Does MYSQL join before LIMIT?
@RolandoMySQLDBA do you consider this a good question? The latter part is a real problem, but this question clearly shows no sign of research...
Feb
21
comment Does MYSQL join before LIMIT?
If you'd did it, you didn't get a downvote from me.
Feb
21
comment Does MYSQL join before LIMIT?
Why haven't you tried yet?
Feb
21
comment Undefined reference to my function
Could you also show the headers of postgres.c and the whole call?
Feb
21
comment Normalisation from 1NF to 3NF
@carlbrooks Just a minor suggestion: since table names can be quite long, you'd better name this table numberofanswers.
Feb
21
comment Connecting a GUI to the user-created function in PostgreSQL
Does mydb live on localhost? Does localhost accept connections? These would be clear if you showed the (error) meassage you'd got.
Feb
21
comment Why is this query so slow?
An execution plan alongside with table and index definitions would definitely help.
Feb
21
comment Altering same table across multiple databases
How can you be sure about that this runs successfully for every single DB?
Feb
21
comment Undefined reference to my function
And how do we know without seeing your code? :)