Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bcrdn-0002G9-3A for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Aug 2016 10:12:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bcrdm-0005lr-KW for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Aug 2016 10:12:06 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bcrdl-0005lY-JV for pgsql-hackers@postgresql.org; Thu, 25 Aug 2016 10:12:05 +0000 Received: from newmail.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bcrdi-0007Lq-Bb for pgsql-hackers@postgresql.org; Thu, 25 Aug 2016 10:12:04 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id B46EA21C2324; Thu, 25 Aug 2016 13:12:00 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Received: from mail.postgrespro.ru ([127.0.0.1]) by localhost (mail.postgrespro.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ceMCWRecUJ_2; Thu, 25 Aug 2016 13:12:00 +0300 (MSK) Received: from [192.168.27.153] (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id 8679B21C231F; Thu, 25 Aug 2016 13:12:00 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1472119920; bh=0odXgzrbU0xaoNadqS+IpPQp3qeL77+TIflB8k75ky0=; h=Subject:To:References:Cc:From:Date:In-Reply-To; b=Ql5lnxgkYL3YIj4Enpwi7WOfmFi7pX1dnLHK/wloL1w6CIB4kFmSqCBmJwbEXybec Wt9I9D9A07I75uP3v7DyA0976splliSaNmuTkVpgV8LWZMq0rOy+fupGcsyX866DeY qCFa0DRaQEb0Bs6s77XfmX1PxJSG+932vlLvq5Tw= Subject: Re: Bug in to_timestamp(). To: Robert Haas , amul sul References: <1873520224.1784572.1465833145330.JavaMail.yahoo.ref@mail.yahoo.com> <31915.1466703655@sss.pgh.pa.us> <32684.1466704957@sss.pgh.pa.us> <734e50cd-c563-4afd-d1c8-80f244b3265e@postgrespro.ru> <1285870380.13225431.1471272994354.JavaMail.yahoo@mail.yahoo.com> <60cc3122-0950-e455-21fe-de89882e285d@postgrespro.ru> <2095510729.14135736.1471444528728.JavaMail.yahoo@mail.yahoo.com> <03e76bef-75eb-4d70-40d6-890d42f4dc8e@postgrespro.ru> <22dbe4e0-b550-ca86-8634-adcda0faa159@postgrespro.ru> Cc: Pavel Stehule , Tom Lane , "David G. Johnston" , Alex Ignatov , Bruce Momjian , PostgreSQL-development From: Artur Zakirov Message-ID: <61a7a060-7d6e-f7a4-29ca-ea4b867146cd@postgrespro.ru> Date: Thu, 25 Aug 2016 13:11:00 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: <22dbe4e0-b550-ca86-8634-adcda0faa159@postgrespro.ru> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.2 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org >>You are right. I assigned to prev_type NODE_TYPE_SPACE to be able to >>execute such query: >> >> >>SELECT to_timestamp('---2000----JUN', 'YYYY MON'); >> >> >>Will be it a proper behaviour? > > > Looks good to me, no one will complain if something working on PG but not on Oracle. Thanks. I've created the entry in https://commitfest.postgresql.org/10/713/ . You can add yourself as a reviewer. -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers