David,
Thanks!
'EXPLAIN ANALYZE' is very slick.
Promises to be very helpful.
As soon as I saw the output, it was obvious where my problem was.
Brad.
On Mon, Mar 6, 2023 at 2:30 PM David G. Johnston
wrote:
> On Mon, Mar 6, 2023 at 1:18 PM Brad White wrote:
>
>>
>> As you can see here, when att
On 3/6/23 1:27 PM, Brad White wrote:
In that picture, it's clear what is happening.
Here, again, is the result that had me stumped.
image.png
What threw me was that the field I was looking for had the format of
6d-4d and this field appeared to have the same format.
But once you expand it, you ca
In that picture, it's clear what is happening.
Here, again, is the result that had me stumped.
[image: image.png]
What threw me was that the field I was looking for had the format of 6d-4d
and this field appeared to have the same format.
But once you expand it, you can see that it has a 6d-7d forma
On 3/6/23 12:48 PM, Brad White wrote:
LOL
Joke's on me.
Here's the relevant part of the view
SELECT ...
"Order Items"."ID" AS "OrderItemID",
...
(("Orders"."ID" || '-'::text) || "Order Items"."ID") AS "FileKey"\
Because "Orders"."ID" is different then "Order Items"."ID"?
W
On Mon, Mar 6, 2023 at 1:48 PM Brad White wrote:
> LOL
>
> Joke's on me.
>
> Here's the relevant part of the view
>
> SELECT ...
> "Order Items"."ID" AS "OrderItemID",
> ...
> (("Orders"."ID" || '-'::text) || "Order Items"."ID") AS "FileKey"
>
> Wait, then why are the Item IDs differe
n why are the Item IDs different?
Here are the results again, with the FileKey field expanded a bit.
[image: image.png]
On Mon, Mar 6, 2023 at 2:23 PM Adrian Klaver
wrote:
> On 3/6/23 12:17, Brad White wrote:
> > I was doing a SELECT * FROM view WHERE field LIKE pattern
> > and g
On Mon, Mar 6, 2023 at 1:18 PM Brad White wrote:
>
> As you can see here, when attempting to filter on the FileKey, it is
> actually filtering on the Order Item ID field.
>
> select "FileKey", "OrderItemID" from "vw_rptInvc_Permits"
> where "FileKey" LIKE '%1317'
>
> I'm stumped. Any guesses?
>
On 3/6/23 12:17, Brad White wrote:
I was doing a SELECT * FROM view WHERE field LIKE pattern
and getting garbage data back.
Turns out it is filtering on a different field.
As you can see here, when attempting to filter on the FileKey, it is
actually filtering on the Order Item ID field
I was doing a SELECT * FROM view WHERE field LIKE pattern
and getting garbage data back.
Turns out it is filtering on a different field.
As you can see here, when attempting to filter on the FileKey, it is
actually filtering on the Order Item ID field.
select "FileKey", "Or
