Skip site navigation (1) Skip section navigation (2)

Re: Inserting data of two other tables [Now deleting ...]

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 (view raw or flat)
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


In response to

Responses

pgsql-novice by date

Next:From: Mauro BertoliDate: 2003-05-28 13:26:19
Subject: Create Table Unique problem... bug?
Previous:From: papapepDate: 2003-05-28 12:52:46
Subject: Re: Inserting data of two other tables [Now deleting ...]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group