Re: Type conversion - Mailing list pgsql-sql

From Ed Loehr
Subject Re: Type conversion
Date
Msg-id 394FCE8E.D522EEB2@austin.rr.com
Whole thread Raw
In response to Type conversion  (Ice Planet <ice@adiemus.sk>)
List pgsql-sql
Tom Lane wrote:
> 
> Ice Planet <ice@adiemus.sk> 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Type conversion
Next
From: Christopher Sawtell
Date:
Subject: Re: \copy...