Reputation
15,089
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 29 55
Newest
 Good Answer
Impact
~933k people reached

11h
awarded  Good Answer
12h
revised Automatic failover mechanism for PostgreSQL
deleted 43 characters in body
13h
reviewed Approve How to join more than one table
Jun
24
revised Connection to a MySQL server fails after server restart
edited tags
Jun
24
revised Is there an equivalent in postgresql to MySQL's “safe update mode” or “safe delete mode”?
edited tags
Jun
24
comment Is there an equivalent in postgresql to MySQL's “safe update mode” or “safe delete mode”?
Are you referring to the MySQL's command line client's parameter --i-am-a-dummy? That depends on the SQL client you are using. Some offer this, some don't. psql does not have such a parameter.
Jun
24
revised Insert from Another Table + Removing Duplicate Entries in Postgres
edited tags
Jun
24
comment Insert from Another Table + Removing Duplicate Entries in Postgres
Exception handling is only available in PL/pgSQL, not in plain SQL - you need to write a stored function to catch an exception. In PL/pgSQL, BEGIN starts a block and does not need a ;. You are confusing BEGIN TRANSACTION; (which is a SQL statement) with the BEGIN from PL/pgSQL: postgresql.org/docs/current/static/plpgsql-structure.html
Jun
23
answered Insert from Another Table + Removing Duplicate Entries in Postgres
Jun
22
revised How to use a view to span two tables that are identical
edited tags
Jun
22
comment I want to move the listbox one to another listbox and update the particular listbox value
Are you really using Postgres and SQL Server and MySQL all at the same time?
Jun
22
revised I want to move the listbox one to another listbox and update the particular listbox value
added 56 characters in body
Jun
22
comment How to see list of databases in Oracle?
@DevYudh: a tablespace in Oracle is something completely different than a "database" in MySQL. The first query if correct, the second query is plain wrong
Jun
22
awarded  Famous Question
Jun
22
comment Remove all character except A-Za-z0-9 without regex
What's wrong with using regex?
Jun
22
comment Pattern matching in PostgreSQL?
No it's not "mostly similar". The syntax is completely different between those three DBMS.
Jun
22
comment Pattern matching in PostgreSQL?
Why the mysql and oracle tags?
Jun
22
comment Sync many client database to one central database
Which DBMS are you using? "SQL" is a query language, not a specific DBMS
Jun
21
revised Intervals query of huge data
edited tags
Jun
19
reviewed No Action Needed Partitioned Database restore is very slow on SQL Server 2012 with SP2