|
Thank you. That works! I was converting my actual query, into something I
The "This" seems to imply the above statement using the VALUES row
clause, but the column in the expression was RAMT instead of AMOUNT and
was unnamed, although the NTE was identified with HalfList; i.e. there
is no HalfAmount named. Perhaps the following [with both a more
explicit column-list selection asking for all columns from each
table-reference vs all from the result-set, and explicit column naming
hoping to make the additional result-column more conspicuous]?:
select INVOICE.*, halflist.*
from INVOICE
, lateral (values(INVOICE.ramt/2)) as halflist (HalfAmount)
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
