From: Peter Eisentraut <e99re41@DoCS.UU.SE>
To: Imtiaz. S. M <imtiaz_sm@yahoo.com>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] SQL Problem
Date: Thu, 28 Oct 1999 12:58:29 +0200 (MET DST)
Message-ID: <Pine.GSO.4.02A.9910281257210.567-100000@Puma.DoCS.UU.SE> (raw)
In-Reply-To: <381829A7.67949B14@yahoo.com>
UPDATE second_table SET date_column = (SELECT min(date_column) FROM
first_table);
On Thu, 28 Oct 1999, Imtiaz. S. M wrote:
> I have two tables which have exactly the same structure. Both of them
> have one datetime column along with three other columns. But the
> datetime column value in the second table is NULL for all the rows. Now
> I want select the least date(date with the least value in the datetime
> column) from the first table and update all the rows in the second table
> with this least date value from the first table. I do not want to use
> any compiler or host variables. I should be able to do this only using
> SQL statements. Cn somebody please help me? Thanks in advance.
>
> regards
> Imtiaz
>
>
> ************
>
>
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: e99re41@DoCS.UU.SE, imtiaz_sm@yahoo.com
Subject: Re: [SQL] SQL Problem
In-Reply-To: <Pine.GSO.4.02A.9910281257210.567-100000@Puma.DoCS.UU.SE>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox