Received: from mail.austin.rr.com (sm1.texas.rr.com [24.93.35.54]) by hub.org (8.10.1/8.10.1) with ESMTP id e5KK0rM44704 for ; Tue, 20 Jun 2000 16:00:53 -0400 (EDT) Received: from austin.rr.com ([24.93.36.87]) by mail.austin.rr.com with Microsoft SMTPSVC(5.5.1877.357.35); Tue, 20 Jun 2000 15:01:55 -0500 Message-ID: <394FCE8E.D522EEB2@austin.rr.com> Date: Tue, 20 Jun 2000 15:05:34 -0500 From: Ed Loehr X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: Ice Planet , pgsql-sql@postgresql.org Subject: Re: Type conversion References: <1728.961530525@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/186 Tom Lane wrote: > > Ice Planet writes: > > B: insert into t2 values (select int2(int4(b)) from t1 where a = 1) > > Works for me when spelled correctly: I think you can also leave out the 'values' for a sub-select insert, though I haven't checked to see if it matters... Regards, Ed Loehr