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.