From: Imtiaz. S. M <imtiaz_sm@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: SQL Problem
Date: Thu, 28 Oct 1999 16:17:03 +0530
Message-ID: <381829A7.67949B14@yahoo.com> (raw)
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
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: imtiaz_sm@yahoo.com
Subject: Re: SQL Problem
In-Reply-To: <381829A7.67949B14@yahoo.com>
* 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