Postgres Pro
Downloads
Home   >   mailing lists

Re: Sub-Select problem - Mailing list pgsql-admin

From Marvin
Subject Re: Sub-Select problem
Date
Msg-id 3F1722A4.000003.03704@guaj215desa
Whole thread Raw
In response to Sub-Select problem  ("Marvin" <magosoft@gmx.net>)
List pgsql-admin
Tree view
I executed the same query on a command line console and it worked
I think the problem is that I'm using EMS PostgreSQL Manager and
it does not return me anything from the SQL Editor.
 
Thank you for the help.
 
MAGO
 
-------Mensaje original-------
 
Fecha: Jueves, 17 de Julio de 2003 04:23:23 p.m.
Asunto: Re: [ADMIN] Sub-Select problem
 
I executed this same query and all the rows have been showed. The only
problem was I had to include field2 in the group by statement.
I am running postgresql 7.2.3-5.80 over Red Hat 8.

----- Original Message -----
From: Marvin
To: pgsql-admin@postgresql.org
Sent: Thursday, July 17, 2003 7:03 PM
Subject: [ADMIN] Sub-Select problem


I was trying to do something like this.

Select Field1, Field2, Total
FROM
(Select Field1, Field2, SUM(Field3) as Total
From TableA
Where DateHired <= CAST('08/01/2003' AS DATE)
GROUP BY Field1) as MyTable;

The sub-select query tested alone returns me a lot of rows,
however when I make all the query it returns me nothing.

Please help!!!
I'm in rush.

Thank you in advanced for ANY suggestion,


MAGO


_________________________________________________________________
IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí

.
_________________________________________________________________
  IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
Attachment

pgsql-admin by date:

Previous
From: "Marvin"
Date:
Subject: Sub-Select problem
Next
From: Bruno Wolff III
Date:
Subject: Re: Where can I find the release notes for 7.3.3?