From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
---|---|
To: | papapep <papapep(at)gmx(dot)net> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Inserting data of two other tables [Now deleting ...] |
Date: | 2003-05-28 13:25:28 |
Message-ID: | 1054128328.1503.4.camel@billy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Am Mit, 2003-05-28 um 14.52 schrieb papapep:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I've made a try with this:
>
> SELECT count(journey) from DETALLTRAJECTES where EXISTS (SELECT NULL
> from CAPTRAJECTE,DETALLTRAJECTES where pkey=journey and fecha=20030423);
>
> and it doesn't work properly (at least it doesn't do what I need...)
>
> In my last mail (this is for Nabil) I made a mistake in what I told you.
> The date to filter the rows to remove is in CAPTRAJECTES, and the rows
> to remove are in DETALLTRAJECTES. CAPTRAJECTES has a field called "pkey"
> and DETALLTRAJECTES another called "journey" that are the join between
> the two tables.
please send us the output of all involved tables with \d
e.g.:
\d DETALLTRAJECTES
bye
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de
From | Date | Subject | |
---|---|---|---|
Next Message | Mauro Bertoli | 2003-05-28 13:26:19 | Create Table Unique problem... bug? |
Previous Message | papapep | 2003-05-28 12:52:46 | Re: Inserting data of two other tables [Now deleting ...] |