Postgres Pro
Downloads
Home   >   mailing lists

Re: garbage data back - Mailing list pgsql-general

From David G. Johnston
Subject Re: garbage data back
Date
Msg-id CAKFQuwYOoHxDgO3dBOdFGgnanO=iVtaVP1JgK1cnVTGd9_xR2w@mail.gmail.com
Whole thread Raw
In response to Fwd: garbage data back  (Brad White <b55white@gmail.com>)
Responses Re: garbage data back
List pgsql-general
Tree view
On Mon, Mar 6, 2023 at 1:48 PM Brad White <b55white@gmail.com> 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.
image.png

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.
Attachment

pgsql-general by date:

Previous
From: Brad White
Date:
Subject: Fwd: garbage data back
Next
From: Adrian Klaver
Date:
Subject: Re: Fwd: garbage data back