Re: garbage data back

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Mon, Mar 6, 2023 at 1:48 PM Brad White <b55white@xxxxxxxxx> 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 different?

Here are the results again, with the FileKey field expanded a bit.

I don't understand what you are questioning...FileKey is a hyphenated concatenation of the ORDER Id and the ORDER ITEM Id, while OrderItemID is just the later - and the suffix of the former matches the later.

David J.