Re: Converting from MS Access field aliases

Joel Richard <postgres@joelrichard.com> writes:
> What's really screwy is what I found when I hooked access into my  
> PostgreSQL database using pgsqlODBC (I know, it's an abomination) and  
> I logged the statements that PostgreSQL was processing. In MS Access  
> this query:

>    SELECT foo AS bar,  bar * 2 AS gleep FROM table;

> became this in PostgreSQL's logs

>    SELECT foo FROM table;

> Vewwy Intewesting!

Yeah, that *is* interesting --- it means Access is trying to do all the
arithmetic for itself.  I guess this means that you could keep using
the statements unchanged if you wanted to use Access as a frontend to
Postgres.  Of course you're trying to get away from that, but this
might at least give you a chance of fixing things incrementally instead
of having to fix everything all at once.
        regards, tom lane