The first query under 'BAD RESULT:' doesn't have anything to do with my question
Please disregard it!
mg=# select * from trans_item where id=20116;
id | trans_id | parent | qty | item_sku | item_price | item_tax
-------+----------+--------+-----+----------+------------+----------
20116 | 11216 | 20115 | 1 | 91400 | 0.50 | 0.0700
(1 row)
^ that
Best,
Tyler Kellen