Something that I did before, but never documented until now was querying the database for all of the PL/pgSQL function definitions. In PostgreSQL, you can run the following to pull all of them along with the owner, schema, function name, and function definition: Of course, you can modify the above Read more…
Instead of rewriting the article myself, I figured it is better to simply link to it: http://mislav.uniqpath.com/2010/05/semicolons/. After reading this article, do remember that just because it is stated that they are not needed doesn’t mean that it is bad to include them. š
This is the answer to the Problem of the Week that was posted on April 30. The desired answer is 0. The reason is because “11” in binary is actually equal to 3. Therefore 3 – 3 = 0. On the other hand, you could use the following table to Read more…
How can you prove or disprove that 1 = 0.999999…? The answer to this Problem of the Week can be found here.
If you are writing a JScript and need a way to copy some text to the clipboard, you can use the following definition: Here is an example code block that calls this function: This function relies on the existence of Internet Explorer on the PC. Of course, this function is Read more…
Have you ever wondered how you can recursively call a JScript? Here is an example which shows how it can be done: It is important to note that the above example will not pass any variables that were passed to it. If you want to try this out on your Read more…
One of my favorite things about JavaScript is the ability to use certain functions to do unexpected things. The following shows you the code that could be used to imitate Prototype’s corresponding function: Basically the above code creates a new array has a length of the specified number plus one. Read more…
One of the things that I love about string manipulation is the existence of regular expressions. For this reason, I have decided to share a few examples that may help those who are learning about regular expressions so that can understand them a bit better. JavaScript – General Variable Name Read more…
Did you know that the language can at times dictate the way people view math? The following is a slight modification of a problem given to me by Matt Emschweiler: A children’s math problem was translated by two different people (a mathematician and a literature major) from two distinct ancient Read more…
One of the things that I am not all that thrilled about is the fact that at times it is hard to find examples of PostgreSQL queries or plpgsql functions. For this reason, I want to help out anyone who would like to see an example of converting a query Read more…