Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j4Msu-0007oT-JM for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Feb 2020 10:47:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j4Mst-0006fL-Ck for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Feb 2020 10:47:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j4Mst-0006fE-2h for pgsql-bugs@lists.postgresql.org; Wed, 19 Feb 2020 10:47:15 +0000 Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j4Msq-0004gb-FK for pgsql-bugs@lists.postgresql.org; Wed, 19 Feb 2020 10:47:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com; s=20170201; h=In-Reply-To:Content-Type:MIME-Version:References:Reply-To: Message-ID:Subject:Cc:To:Sender:From:Date:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=lm5l0QL+RnzJneNSvtWgi+NRnKiVM8th02fmBWCmryw=; b=g3TKKZLcg4TMhBrLPxzDLzsNU5 OX3kvxYmdY9CYByDuxZAbgx0Iu73CPYCJrmY7O8y+5yDnfVKTGzddxjXSFpJhs7FxknVdjNPyLOk4 /yIaz/2S1BTOpWOcHHdfVHif6LEcZ4osMdopwRFvLKiyYWvmhwAku2cJDIVZUxjVGXS0=; Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com) by depesz.com with esmtpa (Exim 4.92) (envelope-from ) id 1j4Msp-0005E3-7b; Wed, 19 Feb 2020 11:47:11 +0100 Date: Wed, 19 Feb 2020 11:47:11 +0100 From: hubert depesz lubaczewski Sender: depesz@depesz.com To: Atila Rangel Cc: pgsql-bugs@lists.postgresql.org Subject: Re: [Bug Report] Week Day Message-ID: <20200219104711.GA1797@depesz.com> Reply-To: depesz@depesz.com References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, Feb 18, 2020 at 11:59:58PM -0300, Atila Rangel wrote: > Hi, I'm a software developer working with Postgresql database. Recently, I > have had a issue with Week Day queries. Basically, I tried to filter some > datetime based on day of week name. I'm sending a sql that you can > reproduce the bug. This may not be a bug. But, I would like to report this. It's not a bug. It is described in https://www.postgresql.org/docs/current/functions-formatting.html : day: full lower case day name (blank-padded to 9 chars) you most likely want to use to_char(some_date, 'FMday') depesz