Difference between text and varchar (character varying)

There is no difference, under the hood it’s all varlena (variable length array). Check this article from Depesz: http://www.depesz.com/index.php/2010/03/02/charx-vs-varcharx-vs-varchar-vs-text/ A couple of highlights: To sum it all up: char(n) – takes too much space when dealing with values shorter than n (pads them to n), and can lead to subtle errors because of adding trailing … Read more

What’s the difference of strings within single or double quotes in groovy?

Single quotes are a standard java String Double quotes are a templatable String, which will either return a GString if it is templated, or else a standard Java String. For example: println ‘hi’.class.name // prints java.lang.String println “hi”.class.name // prints java.lang.String def a=”Freewind” println “hi $a” // prints “hi Freewind” println “hi $a”.class.name // prints … Read more