From: | John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com> |
---|---|
To: | Igor Korot <ikorot01(at)gmail(dot)com> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Backward compatibility |
Date: | 2017-07-22 12:44:59 |
Message-ID: | CAAJSdjjQkFftuWQYtYXANfbfdgPvqR2ow-jW0whNAQwjAAm9XQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jul 21, 2017 at 10:21 PM, Igor Korot <ikorot01(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2017-07-22 14:30:38 | Re: Backward compatibility |
Previous Message | Alessandro_feliz | 2017-07-22 08:28:04 | Re: Postgres csv logging |