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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sTjoR-001vLo-8x
	for pgsql-general@arkaria.postgresql.org; Tue, 16 Jul 2024 15:09:55 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sTjoP-001Zc8-Vg
	for pgsql-general@arkaria.postgresql.org; Tue, 16 Jul 2024 15:09:53 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ray@rodonnell.ie>)
	id 1sTjoP-001Zc0-IE
	for pgsql-general@lists.postgresql.org; Tue, 16 Jul 2024 15:09:53 +0000
Received: from srv01.teladesign.ie ([2001:41c9:1:41d::10])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ray@rodonnell.ie>)
	id 1sTjoM-002Ql3-2a
	for pgsql-general@lists.postgresql.org; Tue, 16 Jul 2024 15:09:52 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=rodonnell.ie; s=exim; h=Content-Transfer-Encoding:Content-Type:In-Reply-To:
	From:References:Cc:To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To:
	Content-ID:Content-Description:Resent-Message-ID;
	bh=i3N/5+OqomlBZh/YDO2A58zBecg4omqd5E1LHLoPy84=; b=Xi6ntqFsuJlmMHGhAzfsNh4ONw
	RHb/OI0QqGEVuGHv1OskW68gRbnSWhxEnnmzZODng07z2E4jNm1NWctRAaUGvl9wklu5oHKj11m7H
	UKqrhhccNShARBrU6OyFkFL8JDPl1lwKSHeL63yzKJaGjEJv6ld3N58mW/Vcn4+I0E0w=;
Received: from [86.43.85.86] (helo=[192.168.1.33])
	by srv01.teladesign.ie with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <ray@rodonnell.ie>)
	id 1sTjoH-0007LP-La; Tue, 16 Jul 2024 16:09:45 +0100
Message-ID: <eddda277-b783-4d4d-adbf-40995a488a5a@rodonnell.ie>
Date: Tue, 16 Jul 2024 16:09:43 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Code does Not Read in FY 2025 Data
To: Anthony Apollis <anthony.apollis@gmail.com>,
 Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@lists.postgresql.org
References: <CAJyMCYJZ9xhgMyLE+U=2xAZ=DbaDb8keCb4pW5_+L4sx9brBdg@mail.gmail.com>
 <1fd63ee5-a8a3-492e-a38d-82ff21da26b8@aklaver.com>
 <CAJyMCYKdUTisoh6pBJfZPkkutqdc3Juj1BbUTeMXO5E157Secg@mail.gmail.com>
Content-Language: en-GB
From: Ray O'Donnell <ray@rodonnell.ie>
In-Reply-To: <CAJyMCYKdUTisoh6pBJfZPkkutqdc3Juj1BbUTeMXO5E157Secg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/eddda277-b783-4d4d-adbf-40995a488a5a%40rodonnell.ie>
Precedence: bulk

On 16/07/2024 15:59, Anthony Apollis wrote:
> I am using Postgres and SQL Server.
> Can you test the data pls.

Adrian has already pointed out a possible cause of the issue you are 
seeing - you should test further based on this.

Ray.


-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie