O$8.0.3 plus Postgres 9.3 and 9.1

[Doug Easterbrook]

so.. what is in #S1.    probably not a field name

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On Sep 7, 2017, at 7:50 PM, Mike Rowan <michael.rowan3 at gmail.com> wrote:
> 
> Good point Greg.  In my app however, ALL column names are unique, so that
> is a problem that has never arisen.
> 
> Cheers and thanks for the interest.
> 
> On Fri, Sep 8, 2017 at 11:12 AM, Grzegorz (Greg) Pasternak <
> grzegorz at myfastcom.ca> wrote:
> 
>> 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 at 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 http://lists.omnis-dev.com
>>> 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com