Blog

The impetus for my question is that I had hoped that PostgreSQL would behave consistently when selecting from citext columns, regardless of whether or not the string to be matched is wrapped in one or more instances of lower() (any such wrapping is beyond my control). That appears not to be the case. (Of course,Read more

Is there an equivalent of PostgreSQL’s Dollar-quoted String Constants, on SQL Server? I would like to enter HTML string literals that would potentially contain single or double quotes in them. Example: UPDATE table_name SET column_name = $ $ Here’s a string that contains “double quotes”. $ $ WHERE condition = trueRead more