Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL-Statement - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: SQL-Statement
Date
Msg-id Pine.LNX.4.44.0309161842320.1863-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to SQL-Statement  (Markus Espenhain <espenhain@etes.de>)
List pgsql-admin
Tree view 
> SELECT * FROM Hauptantrag WHERE (select datenfeldname from datenexport)
> > (select datum_von from datenexport) AND (select datenfeldname from
> datenexport) < (select datenexport.datum_bis from datenexport) limit 10;

It is not correct. You have not defined the condition between hauptantrag
& datenexport tables. Forward the table structures for assistance.

regards,
bhuvaneswaran

pgsql-admin by date:

Previous
From: Jose Vicente Nunez Z
Date:
Subject: Inserting 26 million rows takes 8 hours, how to improve those times?
Next
From:
Date:
Subject: Re: postgresql headers