Defining constants in Pl/pgSQL, with a twist

For the past few months i have been thinking about how to implement constants (like for example order status codes) in your code so that you maintain readability even when the constants are defined as integers and you can’t do anything about it. Of course i would prefer having status codes as text (eg. order […]

Posted at 6:06 pm on March 2, 2008 | 5 comments | Filed Under: postgresql, sql, tips&tricks | Continue reading

PostgreSQL substring search

As most of you have probably discovered there is no nice way to do substring search in PostgreSQL however where’s a will there’s a way. The following post is about overcoming this limit, as with all such cases it is somewhat specific to the problem that we are solving and has it’s drawbacks. However i […]

Posted at 9:07 pm on December 11, 2007 | 35 comments | Filed Under: postgresql, query tuning, sql, tips&tricks | Continue reading