Was working with MySQL recently. Noticed that UPDATE command of it has special LIMIT clause which is really useful as for me, e.g. UPDATE `Product_download` SET `version`=’9.2.1′ WHERE `product_download_id`=367 LIMIT 1;
Pasha Golub's Blog
Nullus est in vitae sensus, ipsa vera est sensus
Blog Archives
CHM-help for PostgreSQL 9.0
By the nature of my work, I use PostgreSQL manuals very often since the 8.x versions. And if for earlier versions it is possible to download CHM help file, for version 9.0 that’s not possible. Quick answer why it’s unbearable…
Poll: ALTER TYPE enumtype ADD <what?> ‘newlabel’
Yesterday, Hubert ‘depesz’ Lubaczewski wrote a post about new functionality in PostgreSQL 9.1. In a few words we will have the ability to add new values to the existing ENUM type defined earlier. Thanks God! However, Andrew Dunstan proposed to…
Poll: Do we need SET type in PostgreSQL?
This topic is discussed again and again with huge friend of mine and MySQL sectarian. And must confess I agree with him in this particular point of view. For me it’s strange that such powerful database as PostgreSQL, which has…
Tagged with: development, grammar, ideology, MySQL, poll, PostgreSQL, SET, SQL, type
Posted in Polls, PostgreSQL
Posted in Polls, PostgreSQL
- Database Designer for PostgreSQL 1.9.0 is out! May 17, 2013
- Database Designer for PostgreSQL 1.9.0 Beta 2 available April 15, 2013
- PostgresDAC v2.9.6 is out! May 14, 2013
- PostgresDAC v2.9.5 released April 18, 2013
- PaGoDump and PaGoRestore v9.2.1 released November 23, 2012
- PaGoDump and PaGoRestore v9.1.3 are available June 6, 2012
- Bruce Momjian: PgCon Developer Meeting Concluded May 22, 2013
- Michael Paquier: Postgres 9.3 feature highlight: new verbose error fields May 22, 2013
- Hans-Juergen Schoenig: Kostal Pico to PostgreSQL May 22, 2013
- Jignesh Shah: How to do Postgres Replication and Failover in VMware vFabric Data Director 2.7? May 22, 2013
- Denish Patel: Inserting JSON data into Postgres using JDBC driver May 22, 2013
