Re: Type conversion

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ice Planet <ice(at)adiemus(dot)sk>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Type conversion
Date: 2000-06-20 20:05:34
Message-ID: 394FCE8E.D522EEB2@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane wrote:
>
> Ice Planet <ice(at)adiemus(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Sawtell 2000-06-20 23:37:34 Re: \copy...
Previous Message Tom Lane 2000-06-20 19:48:45 Re: Type conversion