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 <psycopg-owner+archive@lists.postgresql.org>)
	id 1jdY1Y-00068L-Ud
	for psycopg@arkaria.postgresql.org; Tue, 26 May 2020 11:45:37 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1jdY1X-0008Ul-UI
	for psycopg@arkaria.postgresql.org; Tue, 26 May 2020 11:45:35 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <rory@campbell-lange.net>)
	id 1jdY1X-0008Ue-Ir
	for psycopg@lists.postgresql.org; Tue, 26 May 2020 11:45:35 +0000
Received: from campbell-lange.net ([178.79.140.51])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <rory@campbell-lange.net>)
	id 1jdY1V-00053q-K7
	for psycopg@postgresql.org; Tue, 26 May 2020 11:45:35 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=campbell-lange.net; s=it; h=In-Reply-To:Content-Type:MIME-Version:
	References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To:
	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=CG2SKK0gA/cheyRZ8gPsYOcrsIb9aWoPHd7LcXmq8o4=; b=AmC+2Igu2YWpYGc1erSSm6tme
	tzNUEhPbXMI0ofBoD0sVcrFwhWzF5hJdiZSt8nEJNr2JGfuYihKcB17WEDR73UUdeyfUED1XTGM3l
	S8hG8WxTTocnSoiaDdMaHrQR4Laf6wdpXvua4IWuNoeAeJI80p8SC5YxWv3cdz/AkwITI=;
Received: from [217.138.52.158] (helo=rory-t450s)
	by campbell-lange.net with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <rory@campbell-lange.net>)
	id 1jdY1T-00055L-3v; Tue, 26 May 2020 11:45:31 +0000
Received: from rory by rory-t450s with local (Exim 4.92)
	(envelope-from <rory@rory-t450s>)
	id 1jdY1e-0005ff-0D; Tue, 26 May 2020 12:45:42 +0100
Date: Tue, 26 May 2020 12:45:41 +0100
From: Rory Campbell-Lange <rory@campbell-lange.net>
To: Frank Millman <frank@chagford.com>
Cc: psycopg@postgresql.org
Subject: Re: Minor issue
Message-ID: <20200526114541.GA21741@campbell-lange.net>
References: <92a25cd6-5b50-3074-0da6-7394db9e0f0a@chagford.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <92a25cd6-5b50-3074-0da6-7394db9e0f0a@chagford.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Precedence: bulk

On 26/05/20, Frank Millman (frank@chagford.com) wrote:
> I have a function that returns a complex SQL query and a tuple of
> parameters. The query is stored inside the function as a triple-quoted
> string, and the parameters are derived depending on the input arguments.
> 
> Sometimes while testing I will comment out some of the SQL using '--'. If
> those lines happen to contain a parameter placeholder ('%s') I expected to
> remove the parameter from the tuple as well.

Could you provide an example?