pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: Noah Misch <noah@leadboat.com>
Cc: Ronan Dunklau <ronan.dunklau@aiven.io>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@lists.postgresql.org, Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Subject: Re: Converting contrib SQL functions to new style
Date: Wed, 8 Jan 2025 13:18:36 +0900
Message-ID: <Z338nKcSEImLC-4I@paquier.xyz> (raw)
In-Reply-To: <20250108025233.12.nmisch@google.com>
References: <3395418.1618352794@sss.pgh.pa.us>
	<3133933.1730855116@sss.pgh.pa.us>
	<ZysEEDZqsnP7GTKA@paquier.xyz>
	<5829980.DvuYhMxLoT@aivenlaptop>
	<ZywSnWzXskAxSDew@paquier.xyz>
	<ZzMSJkiNZhimjXWx@paquier.xyz>
	<20250106190428.ec.nmisch@google.com>
	<Z33joDRv_r_gJSd9@paquier.xyz>
	<20250108025233.12.nmisch@google.com>

On Tue, Jan 07, 2025 at 06:52:33PM -0800, Noah Misch wrote:
> It's more optimal to write '0'::bigint.  That generates a CONST node, whereas
> 0::bigint generates a FUNCEXPR calling the cast function.  No other concerns.

Makes sense, done this way.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (44+ messages)

Message-ID: <Z338nKcSEImLC-4I@paquier.xyz>
Permalink:  ../Z338nKcSEImLC-4I@paquier.xyz/
Also on:    postgresql.org/message-id/Z338nKcSEImLC-4I@paquier.xyz

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: michael@paquier.xyz, noah@leadboat.com, ronan.dunklau@aiven.io, tgl@sss.pgh.pa.us, peter.eisentraut@enterprisedb.com
  Subject: Re: Converting contrib SQL functions to new style
  In-Reply-To: <Z338nKcSEImLC-4I@paquier.xyz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox