Subject: String Concatenation does not work.

Поиск
Список
Период
Сортировка
От leshan@ugsolutions.com
Тема Subject: String Concatenation does not work.
Дата
Msg-id 369394CB.CC9B0515@ugsolutions.com
обсуждение исходный текст
Список pgsql-general
>I tried to place a query like "SELECT * FROM x WHERE a = b || c" where
> a, b and c are text columns in table x.
> Unfortunately all I get are Syntax Errors pointing to the
concatenation
> operator. This happens under 6.3.<latest> with psql and jdbc.
> Am I just tripping over a bug or do have to use some kind of escaping?

> Regargs,
>        Holger Klawitter

Well in version 6.4 this works:
  SELECT * FROM x WHERE a = b or a=c;

Hope that helps.
J.L.


В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Patch 6.4.1 to 6.4.2
Следующее
От: Mark Joseph Holmes
Дата:
Сообщение: PostgreSQL 6.4.1 backup procedure on live web server