PostgreSQL

Almost every non trivial application uses in some way a database. For many years this has been anyway Oracle, DB2 or MS-SQL-Server, depending mostly on the habits and on the religious orientation of the organization that developed or ran the application. These days all three are available for Linux and MS-Windows. DB2 is also available […]

Share Button

The magic trailing space

When comparing string, of course spaces count as well and they should count. To ignore them, we can normalize strings. Typical white space normalization includes the following (Perl regular expressions): /[ \t]+/ /g replace any sequence of tabs and spaces used to separate content by one space. /\r\n/\n/g replace carriage return + linefeed by linefeed […]

Share Button