Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qwPAa-00BTrc-DI for pgsql-admin@arkaria.postgresql.org; Fri, 27 Oct 2023 15:54:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qwPAZ-00GuSI-0k for pgsql-admin@arkaria.postgresql.org; Fri, 27 Oct 2023 15:54:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qwPAY-00GuS7-LW for pgsql-admin@lists.postgresql.org; Fri, 27 Oct 2023 15:54:42 +0000 Received: from mail-ej1-x632.google.com ([2a00:1450:4864:20::632]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qwPAV-002ayA-Ft for pgsql-admin@postgresql.org; Fri, 27 Oct 2023 15:54:41 +0000 Received: by mail-ej1-x632.google.com with SMTP id a640c23a62f3a-99357737980so356054166b.2 for ; Fri, 27 Oct 2023 08:54:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1698422078; x=1699026878; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=a6ElYbZjeRNXSlN6FVCNjmX3FYT5LcCA3sSP0hOa9Os=; b=0Vz/ofKf1kc7Bpg8KApBXlp3Ylqguge1p8VmB7cpbXji6qHgETyD/1ST4R9QJeU+tU lo6wEXx2d2o1ezXBp98jfAdeN6WfXxGxOD69W8rqslheagkzzHKVFbtERr4+fWeJH7op 5lHyb4QspDLM4DimAdtsE5cuGWAZSU1r/IXM4fDM8Y5NuHIEEcc1efnTUnqeSQlOx9fc pNjo0ezjLynXZuuVq7ZGIjaM+kzZSpce4x9+yjj8Wxk5b+hY/PTrpu9kIoXC35rp/XgV kIx2IsYziLFCppfWfkUSpiI4qGPkGzw50dS+znNp+mW/3sr9A0k190/p0ce5ZCFaO3In +AvA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698422078; x=1699026878; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=a6ElYbZjeRNXSlN6FVCNjmX3FYT5LcCA3sSP0hOa9Os=; b=SlhDRZQjGzrmSxhQFhet6FIpbz91Q2QbTHTIm0DIuuj6/GRTgDtaLP5OTQInMXaS0s L6EBb1vKtBM5tEUdiBZugnPxlxjxKHxrMfmdUMSsE0219j+5ZnwfcczHJbaV+E1XPtwg JHjse19n+OQ171RsSU2CroC6x/jhPSoYk9Jgf9xTj3A8/W8oNxbNXaTaFrwvoXXkpfbN BprckwgCuku8PBxr0ompl8an4f7mhX/7g4eg5XadkxdaA7rbCVZTIatHS9DEyyu9i1yr a6C6IhRSN3jrL3WjqKKN8zKffblQSPaaPk8ZeWA+RKXXckwSc6bg4/NwU7EkQt+xU5go 9Gag== X-Gm-Message-State: AOJu0Ywzm0Y4h5TKZSE1J5EU/vOr5EbqiyN4/G2azwOzsm5ZeWKMDx0f UXWNMeHGl0jNPPWncoAGnybDFElhKqpSDvwxLLk= X-Google-Smtp-Source: AGHT+IE7Eunik7enUxh9C/x1ZbOj3GyozQOjrSJUQ2pkEaKzxLjMjnH3XaQjEhPE6j0RMNK5TvwiYA== X-Received: by 2002:a17:907:2ce1:b0:9c5:cfa3:d030 with SMTP id hz1-20020a1709072ce100b009c5cfa3d030mr2329978ejc.54.1698422077670; Fri, 27 Oct 2023 08:54:37 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:8321:e6fd:49be:4e52:be26]) by smtp.gmail.com with ESMTPSA id x8-20020a1709065ac800b009adc81bb544sm1376475ejs.106.2023.10.27.08.54.37 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 27 Oct 2023 08:54:37 -0700 (PDT) Message-ID: <02b23b24c9c76b5101b8ca784dfc9f52e65c68c4.camel@cybertec.at> Subject: Re: ORDER BY DESC and NULLS LAST by default From: Laurenz Albe To: Loles , pgsql-admin@postgresql.org Date: Fri, 27 Oct 2023 17:54:36 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2023-10-27 at 16:16 +0200, Loles wrote: > Can the server be configured so that the default ORDER BY option is DESC = instead of ASC? >=20 > And to make it NULLS LAST instead of NULLS FIRST? That is not simple. You'd have to create new data types with new operators that do just the opposite of the normal ones. I'd advise against it. Yours, Laurenz Albe