PG SQL and LIKE clause
От | Matthias Apitz |
---|---|
Тема | PG SQL and LIKE clause |
Дата | |
Msg-id | 20190913052846.GA3070@c720-r342378 обсуждение исходный текст |
Ответы |
Re: PG SQL and LIKE clause
Re: PG SQL and LIKE clause Re: PG SQL and LIKE clause Re: PG SQL and LIKE clause Re: PG SQL and LIKE clause |
Список | pgsql-general |
Hello, We're porting a huge Library Management System, written using all kind of languages one can think of (C, C++, ESQL/C, Perl, Java, ...) on Linux from the DBS Sybase to PG, millions of lines of code, which works also with DBS Oracle and in the past with INFORMIX-SE and -ONLINE. We got to know that in CHAR columns with trailing blanks a SELECT ... FROM ... WHERE name LIKE 'Ali' does not match in 'name' having 'Ali '. I glanced through our code with grep pipelines and found some hundred places which would be affected by this problem. I'm not interested in a religious discussion if or if not this behaviour of PG is correcter or better than in Sybase. It's just different to Sybase. Any hints to address this problem? Or is there any compile time option for the PG server to address this? Thanks matthias -- Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub Mientras haya voluntad de lucha habrá esperanza de vencer.
В списке pgsql-general по дате отправления: