Re: [SQL] Type conversion

[Ed Loehr]

Tom Lane wrote:
> 
> Ice Planet <[EMAIL PROTECTED]> 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