Re: PQfnumber and duplicate column names....

Ralf Hasemann <rhasemann(at)mac(dot)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