IronPort-Data: A9a23:jT04V6oEZXl7+t+xxb/pG3t4T6deBmIQZRIvgKrLsJaIsI4StFCzt
 garIBmGPqzcNGSjeoxzb9uy/EhS6MfXzdRkSAdrqXxgFSgaouPIVI+TRqvSF3rPcZeTEh4PA
 +byyDXkBJppJpMJjk71atANlVEliOfQAOC6ULWYUsxIbVcMYD87jh5+kPIOjIdtgNyoayuAo
 tqaT/f3YDdJ4BYqdDtJg06/gEk35qmq5WpD5gZWic1j5TcyqVFEVPrzGonsdxMUcqEMdsamS
 uDKyq2O/2+x13/B3fv8z94X2mVTKlLjFVDmZkh+AsBOsTAazsAG6ZvXAdJHAathZ5VlqPgqo
 DlFncTYpQ7EpcQgksxFO/VTO3kW0aGrZNYrLFDn2fF/wXEqfFPtx9hqAngGPbYE58hxW21u8
 OITAigSO0Xra+KemNpXS8FlgsIiKMDuZsUWoHAm0DfYSPYrQJzOR6/H/9Ae0DpYasJmRKyPI
 ZBBN3w2NU6GPkIn1lQ/UfrSmM+tnXXydjlVqXqcv6tx/m7SiQx80bTgNNDYYNPMScg9ckOw/
 DmXpTSjXEBAXDCZ4RaZy2qFguXupz/qeoYYHoex+d1VoHTGkwT/DzVMDADq/KLn4qKkYPpHJ
 FcN/m8hoK4/7kWvZt38RAGj5maDpQITQddLCul87xuCopc4+C6QAm4FSjdELs4vtIkrQz1v1
 lKIk97tDzF1v/uZRBpx64t4sxuzPQURI1YyZRQYUCUDudXDpZ84pArQG4ML/LGOsvX5HjT5w
 javpSc4hqkOgcNj60ld1Q2b695LjsWSJjPZ9jnqsnSZAhRRSKPNWmBFwVHf6/dEJYPfXFCB+
 mUCmo2e4eECAJWHmTaCBukAdF1I2xpnGGaM6bKMN8B/n9hIx5JEVdoIiAyS3G8zbq45lcbBO
 Sc+eWp5vfe/xkeCY65teJ6WAM8316XmHtmNfqmLMoUWPcQuK1TXpH0GiausM4bFzRREfUYXZ
 MzzTCpQJShy5VlPlWHvHL1NuVPV7nlnnT+7qW/HI+SPi+PFNSPOF9/pwXOTaOEn4bmfoRnc/
 soXN8aLxxhbWuDkbUHqHX07czg3wLlSLc6elvG7gcbZeVo+Qj9/UqSJqV7jEqQ895loei7z1
 inVcidlJJDX3BUr9S3ihqhfVY7S
IronPort-HdrOrdr: A9a23:TtdJBKog76tOy3cBJQsrDiUaV5oFeYIsimQD101hICG9Kvbo8/
 xG785rsiMc6QxhIk3I9urhBEDtex7hHNtOkOws1NSZLXTbUQmTXeJfBOLZqlWKcREWtNQtt5
 uIGJIQNDSENzlHZLHBjjVQfexN/DDNytHPuQ6X9QYVcekhAZsQlzuRJDzraXFLeA==
Date: Tue, 13 May 2025 16:48:11 +0200
From: Markus Demleitner <msdemlei@ari.uni-heidelberg.de>
To: pgsql-general@lists.postgresql.org
Subject: Re: Index not used in certain nested views but not in others
Message-ID: <20250513144811.enpwh6sm5klsbkoc@victor>
References: <20250430151647.7kootztymzznydn5@victor>
 <1400978.1746046929@sss.pgh.pa.us>
 <91e617539ff887f1aac4e27bf1481b51fcf4b131.camel@cybertec.at>
 <20250512141217.4dwnfxbaf53mhvi7@victor>
 <3847.1747145566@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <3847.1747145566@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/20250513144811.enpwh6sm5klsbkoc%40victor>
Precedence: bulk

Dear Tom,

On Tue, May 13, 2025 at 10:12:46AM -0400, Tom Lane wrote:
> Markus Demleitner <msdemlei@ari.uni-heidelberg.de> writes:
> >   SELECT
> >     CAST(ssa_dstype AS text) AS dataproduct_type,
> >     CAST(NULL AS text) AS dataproduct_subtype,
> >     CAST(2 AS smallint) AS calib_level,
> >     ...
>
> Oh, well, that's your problem.  The source tables' column types
> need to match.  Otherwise the UNIONs don't get flattened and you
> don't get indexscans.

Ahhhh... *source* tables.  Sure, once I'm out of desperation stun, it
kind of is unsurprising that the casts won't help me when it's about
pulling up the original tables.

Just to be sure: int and bigint don't mix, and neither do real and
double precision, right?  And the lazybone in me can't resist asking:
there's absolutely no way around this?

Thanks for setting my head straight,

         Markus