Ralf Hasemann <rhasemann@mac.com> writes:
> What happens if the statement looks like:
> select 1 as FOO, 2 as FOO; (the database has no probs with that)
> What result will PQfnumber return ????
When in doubt, look in the source code ...
/*
* PQfnumber: find column number given column name
*
* The column name is parsed as if it were in a SQL statement, including
* case-folding and double-quote processing. But note a possible gotcha:
* downcasing in the frontend might follow different locale rules than
* downcasing in the backend...
*
* Returns -1 if no match. In the present backend it is also possible
* to have multiple matches, in which case the first one is found.
*/
regards, tom lane