Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAB4b-0006cL-TK for pgsql-sql@arkaria.postgresql.org; Wed, 19 Jan 2022 13:32:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nAB4a-00048e-KJ for pgsql-sql@arkaria.postgresql.org; Wed, 19 Jan 2022 13:32:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAB4a-00047O-7b for pgsql-sql@lists.postgresql.org; Wed, 19 Jan 2022 13:32:24 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nAB4X-00058N-Ob for pgsql-sql@lists.postgresql.org; Wed, 19 Jan 2022 13:32:23 +0000 Received: by mail-pl1-x635.google.com with SMTP id s9so315859plg.7 for ; Wed, 19 Jan 2022 05:32:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=M/obbmDt0YLWnFsTL/+r/v32XJu+300YJqGyGtmdYBQ=; b=GAni+K/tslmNM/Jv2tF4Gqxd7s9UPZYn0mrv96NqHDProUf56qK9VzEcI7GSpvC4VS RhJwS34+ZMRaMBwRrRcGCmPsdjf9mFZ3PLkQgES98LuzFxMdv8I95aFC58ID4+Ep9llh KVUbouCe38CAktTvvcG7EGc5tD6uTqCQyb85rHngyDLxTHIdmn26XH/KcwJf7BscmDES fMiwJSDImCDBNk5dVZ2bIo9FDOPHowXZvfFsrZhpT0kuj4T+tYb7YhIMs4vqB0fyBmBz sifBpb3Rd3Fa7kGUp+rxmZ05TExZztngb7LLX3XVQv1ARrAOHk1u3ZDsqDLdJ9+6+UHJ +yfg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=M/obbmDt0YLWnFsTL/+r/v32XJu+300YJqGyGtmdYBQ=; b=aQPuRYg9a1PRUuG9b7oBwYS2ZJmKOvHA6mun06r1bsXLrN9eQOIYnl1LKq3AOTTRGN ghaiP6RAto9YNphhPFERBSk8G3u0LUtgkQNXKJzuE2ze2R5ktPCV7MNmi8Ko75OfZxgf Wke1OF13aeSWwBS/WIYhq1grIceFJDeifkM/6I5Ud62VCgPf7SERg5ZXHzpqFWqbyV6R Bm/vEyQqn3f7y9L5hjMvKbyWChianp3dEzI56V4IX5Z653oh9lGiY0vp+ptb6qRP7iQt nQY41LIdgjPh+aU/msmInQgmwY9OyshEvTuYdU264sXLKfduyWb78NMMhR5+m7KYA5Ad PkkQ== X-Gm-Message-State: AOAM533X6CSHmwmPJypEPxq0d/RFqfAHcez2i2Z6drhe7Hp12h97gVDr 0faUAodHJEN+m4RV5nmMiZRf8wesGZk= X-Google-Smtp-Source: ABdhPJywSfbcf87LmurIqAvg3Vp/d9f+IuNbBAi6JeVwKGAInRWcfQDHjFb6AGoSy7IO8ycKSDLZFg== X-Received: by 2002:a17:90b:3b46:: with SMTP id ot6mr4362093pjb.104.1642599140484; Wed, 19 Jan 2022 05:32:20 -0800 (PST) Received: from smtpclient.apple ([2601:681:5500:dde0:ed95:b2ef:55d1:bc36]) by smtp.gmail.com with ESMTPSA id b2sm22253665pfl.138.2022.01.19.05.32.20 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 19 Jan 2022 05:32:20 -0800 (PST) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Clean up shop database Date: Wed, 19 Jan 2022 06:32:19 -0700 Message-Id: References: <20220119141711201637.c796844d@klingler.net> Cc: pgsql-sql@lists.postgresql.org In-Reply-To: <20220119141711201637.c796844d@klingler.net> To: Richard Klingler X-Mailer: iPhone Mail (19B74) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > No it does not...but I assume it lists products that where at least > ordered before January 1st 2021 > as it contains lower product IDs. > > Hmm..gives me: > >> ERROR: function max(boolean) does not exist > LINE 5: having max(o.orderdate < '2021-01-01') > > Sorry > > max(o.orderdate )< '2021-01-01' >