Re: Backward compatibility

[John McKown <john.archie.mckown@xxxxxxxxx>]

On Fri, Jul 21, 2017 at 10:21 PM, Igor Korot <ikorot01@xxxxxxxxx> 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