X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id C96AF924DCA
	for <pgsql-sql@postgresql.org>; Tue, 27 May 2003 10:38:16 -0400 (EDT)
Received: from developer.postgresql.org ([64.117.224.193])
	by localhost (developer.postgresql.org [64.117.224.193:10024])
	(amavisd-new) with ESMTP id 87057-04 for <pgsql-sql@postgresql.org>;
	Tue, 27 May 2003 10:38:12 -0400 (EDT)
Received: from bsil.com (unknown [203.199.84.175])
	by developer.postgresql.org (Postfix) with ESMTP id 39EBF921BE8
	for <pgsql-sql@postgresql.org>; Tue, 27 May 2003 10:38:11 -0400 (EDT)
Message-ID: <000801c3245d$813bbc40$82060080@VikasSawant>
Reply-To: "Vikas" <svikas@bsil.com>
From: "Vikas" <svikas@bsil.com>
To: <pgsql-sql@postgresql.org>
Subject: Help required on update query
Date: Tue, 27 May 2003 20:07:30 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01C3248B.9A9843B0"
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/590
X-Sequence-Number: 13755

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C3248B.9A9843B0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Christoph,Could you please let me know the syntax for set newCol=3DoldCo=
l, (This is reference to your mail pasted below)RegardsVikas Sawantsvikas@b=
sil.com>
> http://fts.postgresql.org/db/mw/msg.html?mid=3D1071582
>
resp.
>
> You can rename your old column, create a new column varchar(100),
update
> ... set newCol=3DoldCol, drop oldCol and rename newCol to oldCol
> See ALTER TABLE doc for this.
>
Ok, this is the accurate solution to minimize side effects.
Thanks to Robert and Andreas for pointing this out.

Regards, Christoph



------=_NextPart_000_0005_01C3248B.9A9843B0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2><FONT face=3DArial size=3D2><PRE>Hi Christ=
oph,</PRE><PRE>Could you please let me know the syntax </PRE><PRE>for set n=
ewCol=3DoldCol, (This is reference to your mail pasted below)</PRE><PRE>Reg=
ards</PRE><PRE>Vikas Sawant</PRE><PRE><A href=3D"mailto:svikas@bsil.com">sv=
ikas@bsil.com</A></PRE><PRE>&gt;
&gt; <A href=3D"http://fts.postgresql.org/db/mw/msg.html?mid=3D1071582">htt=
p://fts.postgresql.org/db/mw/msg.html?mid=3D1071582</A>
&gt;
resp.
&gt;
&gt; You can rename your old column, create a new column varchar(100),
update
&gt; ... set newCol=3DoldCol, drop oldCol and rename newCol to oldCol
&gt; See ALTER TABLE doc for this.
&gt;
Ok, this is the accurate solution to minimize side effects.
Thanks to Robert and Andreas for pointing this out.

Regards, Christoph


</PRE></FONT></FONT></DIV></BODY></HTML>

------=_NextPart_000_0005_01C3248B.9A9843B0--