O$8.0.3 plus Postgres 9.3 and 9.1
Just a quick comment, I would advise to always fully qualify column names in your LEFT JOIN clause to avoid any ambiguity and consequently errors.
On Sep 7, 2017, at 9:37 PM, Mike Rowan <firstname.lastname@example.org> wrote:
> The following slightly simplified query in which iCol1, iCol5 are as
> iCol1 integer 64 bit
> iCol5 character simple char 1
> SELECT @[iCol1] AS ref, @[#S1], @[iCol5]
> FROM company, branch, purchaseorder
> LEFT JOIN contact ON (ct_id = po_ct_id)
> co_id = br_co_id
> AND br_id = po_br_id
> AND po_invoice_nr >= 10000000
> AND po_invoice_nr <= 10000100 AND ((po_type = 1) OR (po_type = 3)) > ORDER BY po_invoice_nr
> LIMIT 20000
> results in this Error message:
> ERROR: could not determine data type of parameter $2
> As I am fairly new to SQL I’m not sure what is wrong. If I omit all terms
> in the SELECT line except the first, there is no error. Any second or more
> term results in the same error.
> Anyone got a minute for this one?
> Manage your list subscriptions at lists.omnis-dev.com
Manage your list subscriptions at lists.omnis-dev.com