11,454 reputation
11945
bio website
location Munich
age
visits member for 3 years, 3 months
seen 44 secs ago

1h
comment PostgreSQL equivalent of MySQL query variables?
@Daniel: if you are serious about learning SQL you should really get used to that. A single statement is almost always faster than two separate statements (not necessarily in MySQL which is optimized for many, small and simple statements. Most other DBMS have much better optimizer and perform better with fewer but more complex queries)
2d
comment How to put more than 1000 values into an Oracle
In short: you can't. There is no way to overcome this limit. You need to either use a temporary table or send multiple statements.
2d
comment How to put more than 1000 values into an Oracle
Cross post: stackoverflow.com/questions/25592436/…
2d
revised How to put more than 1000 values into an Oracle
edited tags
2d
comment What does GID stand for in PostgreSQL
You need to ask whoever created that table, he/she should know what gid means.
2d
comment What does GID stand for in PostgreSQL
You should know, after all you created the table. Or do you by any chance mean the column oid?
Aug
31
revised Emulating WITH clause in MySQL/query perfomance review
added 168 characters in body
Aug
30
comment Postgres_Failover Not Working
Have look at repmgr. It is a really cool tool that makes setting up replication and doing the failover much easier.
Aug
30
reviewed Leave Closed Log File Size near 100% - How to find Active Transaction
Aug
30
reviewed Leave Closed Proposal: MySQL blob handling revision
Aug
30
reviewed Leave Closed Technical documentation for Replication
Aug
30
reviewed Approve suggested edit on Is there any difference at all between NUMERIC and DECIMAL?
Aug
30
reviewed Approve suggested edit on From freelancer to team of two : best way to share/sync db?
Aug
30
reviewed No Action Needed How to populate Oracle 10g tables related via foreign key?
Aug
29
revised Log File Size near 100% - How to find Active Transaction
edited tags
Aug
29
comment Error while inserting values in array in Postgresql
You should define V_RECORDS_IDS as varchar(32)[]. Using char (or character) is almost always a bad choice (not to so say a mistake)
Aug
29
revised Oracle 11 table design for better performance for reports?
edited body
Aug
29
revised Can I use PHP function strtotime() in SQL queries?
added 11 characters in body
Aug
28
revised table check constraint, greater than > not accepting
Improved formatting
Aug
28
comment MySQL JDBC does not behaves as the MySQL Workbench
Unrelated but: it doesn't make sense to start a transaction for DDL statements in MySQL. You can't roll them back anyway.