Re: [GENERAL] Backward compatibility

Поиск
Список
Период
Сортировка
От John McKown
Тема Re: [GENERAL] Backward compatibility
Дата
Msg-id CAAJSdjjQkFftuWQYtYXANfbfdgPvqR2ow-jW0whNAQwjAAm9XQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Backward compatibility  (Igor Korot <ikorot01@gmail.com>)
Ответы Re: [GENERAL] Backward compatibility
Список pgsql-general
Дерево обсуждения
On Fri, Jul 21, 2017 at 10:21 PM, Igor Korot <ikorot01@gmail.com> wrote:
Hi, guys,
Below query does not even run:

SELECT version(), substring( version() from position( '\s' in version() ) );

Could you spot the error?


​works for me.

psql
psql (9.5.7)
Type "help" for help.

joarmc=# SELECT version(), substring( version() from position( '\s' in version() ) );
                                                  version                                                   |                                                 
 substring                                                   
-------------------------------------------------------------------------------------------------------------+------------------------------------------------
-------------------------------------------------------------
PostgreSQL 9.5.7 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 6.3.1 20161221 (Red Hat 6.3.1-1), 64-bit | PostgreSQL 9.5.7 on x86_64-redhat-linux-gnu, co
mpiled by gcc (GCC) 6.3.1 20161221 (Red Hat 6.3.1-1), 64-bit
(1 row)

​


--
Veni, Vidi, VISA: I came, I saw, I did a little shopping.

Maranatha! <><
John McKown

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