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
In response to
pgsql-novice by date
|Next:||From: Scott Marlowe||Date: 2004-07-29 07:28:48|
|Subject: Re: UNIX timestamps|
|Previous:||From: Eduardo Vázquez Rodríguez||Date: 2004-07-28 23:38:02|
|Subject: UNIX timestamps|