[Tickets #10346] Re: Syntax error in Horde_ActiveSync_State_History->listDevices()

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/10346
------------------------------------------------------------------------------
  Ticket             | 10346
  Updated By         | botner at univention.de
  Summary            | Syntax error in
                     | Horde_ActiveSync_State_History->listDevices()
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Assigned
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


botner at univention.de (2011-07-20 07:14) wrote:

> No, there is no comma missing and it's not ambiguous. "device_id" is  
> a column alias for "d.device_id". We don't want two columns of  
> device_id returned (they are the same value). It's used so the  
> returned data is keyed as "device_id" and not "d.device_id".  
> However, maybe postgres doesn't like the alias to be named the same  
> as a column name.

ah, ok, the problem is that postgres requires AS when specifying alias  
names for output columns

-> SELECT d.device_id AS device_id, device_type, device_agent, ...