MIME-Version: 1.0
References: <CAJyMCYJZ9xhgMyLE+U=2xAZ=DbaDb8keCb4pW5_+L4sx9brBdg@mail.gmail.com>
 <1fd63ee5-a8a3-492e-a38d-82ff21da26b8@aklaver.com> <CAJyMCYKdUTisoh6pBJfZPkkutqdc3Juj1BbUTeMXO5E157Secg@mail.gmail.com>
In-Reply-To: <CAJyMCYKdUTisoh6pBJfZPkkutqdc3Juj1BbUTeMXO5E157Secg@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 16 Jul 2024 09:25:49 -0700
Message-ID: <CAKFQuwaBJY6JRjUxU37xeraOfP4U0Wk9j=5BoFTYrbQbSeuQcA@mail.gmail.com>
Subject: Re: Code does Not Read in FY 2025 Data
To: Anthony Apollis <anthony.apollis@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ad40ee061d5fce07"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwaBJY6JRjUxU37xeraOfP4U0Wk9j%3D5BoFTYrbQbSeuQcA%40mail.gmail.com>
Precedence: bulk

--000000000000ad40ee061d5fce07
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Jul 16, 2024 at 7:59=E2=80=AFAM Anthony Apollis <anthony.apollis@gm=
ail.com>
wrote:

> I am using Postgres and SQL Server.
> Can you test the data pls.
>
>>
>>
Well, this is a PostgreSQL community so you should target it with your
communications.

If you want someone to actually test things here you probably will need to
produce a psql script that constructs the relevant database objects,
populates them, and then executes and produces the empty result you are
claiming you see.

In lieu of psql you could use an online fiddle to build this into a
self-contained executable form.  Here is a link to one.

https://dbfiddle.uk/btGcOH30

David J.

--000000000000ad40ee061d5fce07
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Jul 16, 2024 at 7:59=E2=80=AFAM Anthony Apollis &l=
t;<a href=3D"mailto:anthony.apollis@gmail.com">anthony.apollis@gmail.com</a=
>&gt; wrote:</span><br></div></div><div class=3D"gmail_quote"><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">I am using Postgres a=
nd SQL Server.=C2=A0<div>Can you test the data pls.</div></div><div class=
=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br></bl=
ockquote></div></blockquote><div><br></div><div class=3D"gmail_default" sty=
le=3D"font-family:arial,helvetica,sans-serif">Well, this is a PostgreSQL co=
mmunity so you should target it with your communications.</div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></d=
iv><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-s=
erif">If you want someone to actually test things here you probably will=C2=
=A0need to produce a psql script that constructs the relevant database obje=
cts, populates them, and then executes and produces the empty result you ar=
e claiming you see.</div><div class=3D"gmail_default" style=3D"font-family:=
arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D=
"font-family:arial,helvetica,sans-serif">In lieu=C2=A0of psql you could use=
 an online fiddle to build this into a self-contained executable form.=C2=
=A0 Here is a link to one.</div><div class=3D"gmail_default" style=3D"font-=
family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" s=
tyle=3D"font-family:arial,helvetica,sans-serif"><a href=3D"https://dbfiddle=
.uk/btGcOH30">https://dbfiddle.uk/btGcOH30</a><br></div><div class=3D"gmail=
_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div c=
lass=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">Dav=
id J.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetic=
a,sans-serif"><br></div></div></div>

--000000000000ad40ee061d5fce07--