Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Christopher SawtellDate: 2000-06-20 23:37:34
Subject: Re: \copy...
Previous:From: Tom LaneDate: 2000-06-20 19:48:45
Subject: Re: Type conversion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group