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

From: papapep <papapep(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Inserting data of two other tables [Now deleting ...]
Date: 2003-05-26 17:38:21
Message-ID: 3ED2510D.6030708@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Continuing with my two-tables problem, and knowing that DELETE only
works with one table, how do I remove rows from, for example, a certain
day, considering that in the second table I haven't got that field, and
that it is in the "header" table (captrajectes)? I've read that I have
to create a transaction, but I can't really see how to do it.

Can you give me a hand?

Thanks in advance.

Josep Sànchez
~ [papapep]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+0lEM2vx52x0kyz4RAhBKAJ9Q1aCOu/Vf4VpyLzbsLb+3cJnZUwCgtRYO
VRBEgtpyQccvviVhbiHDwuk=
=WYHr
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-05-26 17:55:28 Re: Inserting data of two other tables [Now deleting ...]
Previous Message papapep 2003-05-26 16:34:52 Re: Altering table error