From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | John McKown <john(dot)archie(dot)mckown(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 14:30:38 |
Message-ID: | CA+FnnTyc=kfO5bzkHUv3WfD=JoPsGTzUuLMH4EF6QUYO4DC1tQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, John,
On Sat, Jul 22, 2017 at 8:44 AM, John McKown
<john(dot)archie(dot)mckown(at)gmail(dot)com> wrote:
> 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)
Weird.
I started a new session of psql and it now works.
But it works incorrectly - it should return:
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
i.e. without the word "PosgreSQL", since '\s' should match the (first)
space in the version().
Thank you.
>
>
>
> --
> Veni, Vidi, VISA: I came, I saw, I did a little shopping.
>
> Maranatha! <><
> John McKown
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-07-22 14:49:56 | Re: Backward compatibility |
Previous Message | John McKown | 2017-07-22 12:44:59 | Re: Backward compatibility |