I respectfully challenge that the aggregation is correct.
In the where clause, I specify A2.AUDIT_TYPE_CODE = CONTENT_2, thus returning
only 2 rows for A2 and not all of the rows in A2 which happen to have a
TXN_COUNT of 1 / row but could in fact be any positive number. I used 1 for
simplici
Please disregard the previous email. After rereading what you sent, I realized
that I need an outer join to A2 and not simply a self join...thanks and my
apologies!
- Original Message
From: Tom Lane <[EMAIL PROTECTED]>
To: Heikki Linnakangas <[EMAIL PROTECTED]>
Cc: Marcus Torres <[EMAI
The following bug has been logged online:
Bug reference: 3960
Logged by: Anto
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Windows Vista
Description:initdb.log
Details:
initdb.log is failed to run while installation.
Please provide t
The following bug has been logged online:
Bug reference: 3961
Logged by: Christoph Dalitz
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.6
Operating system: Linux
Description:ecpg lacks SQLSTATE macro definition
Details:
While ecpg defines the (deprecated)
Anto wrote:
The following bug has been logged online:
Bug reference: 3960
Logged by: Anto
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Windows Vista
Description:initdb.log
Details:
initdb.log is failed to run while installation.
Pl
The following bug has been logged online:
Bug reference: 3962
Logged by: Arjan Bolmer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.0-1
Operating system: Vista
Description:Error on database cluster
Details:
When installing postgreSQL i ran into an error w
Hallo Christoph,
On Thu, Feb 14, 2008 at 11:09:11AM +, Christoph Dalitz wrote:
> Description:ecpg lacks SQLSTATE macro definition
Thanks for reporting this oversight. I added the definition to CVS, also
for 8.2.
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael
Michael Meskes <[EMAIL PROTECTED]> writes:
> Hallo Christoph,
> On Thu, Feb 14, 2008 at 11:09:11AM +, Christoph Dalitz wrote:
>> Description:ecpg lacks SQLSTATE macro definition
> Thanks for reporting this oversight. I added the definition to CVS, also
> for 8.2.
Michael, we branched
The following bug has been logged online:
Bug reference: 3963
Logged by: Ronald Mora
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: windows xp
Description:trigger delete
Details:
Para la modificacion de los datos de los cliente, cree trig