Posts Tagged ‘PostgreSQL’
SQL Collations & Case Sensitive Searches
Posted by: Vijay Dev on: April 14, 2009
I got a question recently from a friend about doing case sensitive searches in SQL and I did not know the answer !! I knew that ORM’s like Django have operators such as ILIKE to do this, but I do not know how to do this in raw SQL. So I started looking for ways [...]
Updates in MySQL and PostgreSQL
Posted by: Vijay Dev on: October 25, 2008
I use MySQL and MS SQL at work and have never used PostgreSQL. So it was a nice learning about the evaluation of the update queries in MySQL and PostgreSQL today..
Seems that UPDATE table SET X=Y, Y=X is enough in PostgreSQL to swap two columns !! It just picks up the old values of [...]
- My Amazon Interview Questions
- Using JODConverter
- Google Telephonic Interview Questions
- MS SQL - DateTime related Functions
- HDFC Mobile Recharge - An Experience
- JForum & MemCached Integration
- Getting the Tomcat Version
- Information Retrieval, Me and Google !!
- Change in behavior in Timestamp.valueOf() in JDK 6
- Yann: Hello! Could you expand your example for the a bit not-so-hapy java users like me, and describe how to compile and run your code? That would be awesom
- Anuraj Pandey: Some one is mis-using my id..i got the notification of the above comment..however i havent posted the comment :(
- Anuraj Pandey: if u have some kind of pdf/text of the material u removed..it will be highly appreciable if u help me..i have my first google intern telephonic interv
I like
- Free Virtualization Software for your Windows PC
- Summary of all the MIT Introduction to Algorithms lectures
- Google Dashboard
- Movie Narrative Charts
- Unlock Hidden Mac OS X Settings With Secrets
- Easy Version Control with Git
- 35 More Useful jQuery Plugins and Techniques
- gogola.New Age Advertising on Twitpic
- Feeds 101
- The Google Timeline in Video – Brilliant.
