O$8.0.3 plus Postgres 9.3 and 9.1
Mike;
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.
Greg
On Sep 7, 2017, at 9:37 PM, Mike Rowan <michael.rowan3@gmail.com> wrote:
> The following slightly simplified query in which iCol1, iCol5 are as
> follows:
>
> 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)
>
> WHERE
> 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?
>
> Mike
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
>
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com