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

Re: Insert using a subselect?

From: "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com>
To: "Pgsql Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Insert using a subselect?
Date: 2001-09-14 02:47:35
Message-ID: HOEFIONAHHKFEFENBMNOIEPICCAA.rsanford@nolimitsystems.com (view raw or flat)
Thread:
Lists: pgsql-novice
yes you can. i do it. it works.

rjsjr

> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Jason Tan
> Sent: Thursday, September 13, 2001 9:39 PM
> To: yFrancisco Reyes
> Cc: Pgsql Novice
> Subject: Re: [NOVICE] Insert using a subselect?
> 
> 
> On Thu, 13 Sep 2001, Francisco Reyes wrote:
> 
> > On Tue, 11 Sep 2001, Jason Tan wrote:
> > 
> > >
> > >
> > > You need to make it return just one row.
> > > It doenst knwo which value to use in the insert.
> > > Jason
> > 
> > so it is not possible to populate an insert from a 
> subselect if there is
> > more than one row/column?
> > 
> 
> I dont think so.
> I _think_ that an insert can only ever insert a single row.
> 
> I _think_ you ahve to do a separate inssert for each row to 
> be inserted.
> 
> But i ma not a postgres experet or an expert on sql and its 
> sematnics,
> just auser.
> My thoughts above are from my won experience, not any 
> absolute knowledge.
> 
> 
> --
> ------------------------------------------------------------
> ------------------
> Jason Tan                                                
> jason(at)rebel(dot)net(dot)au
>      "Democracy is two wolves and a lamb voting on what to 
> have for lunch. 
>                  Liberty is a well-armed lamb contesting the vote."
>                                ~Benjamin Franklin, 1759
> ------------------------------------------------------------
> ------------------
> 
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 

In response to

pgsql-novice by date

Next:From: Dennis LeeuwDate: 2001-09-14 14:28:21
Subject: Post Installation problem
Previous:From: Jason TanDate: 2001-09-14 02:39:04
Subject: Re: Insert using a subselect?

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