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: (view raw, whole thread or download thread mbox)
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...

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-2017 The PostgreSQL Global Development Group