Subselects to populate a table - Mailing list pgsql-novice

From Chris Boget
Subject Subselects to populate a table
Date
Msg-id 003701c2b32b$9f521ec0$8c01a8c0@ENTROPY
Whole thread Raw
In response to How to determine the type of a column  ("Ville Jungman" <ville_jungman@hotmail.com>)
Responses Re: Subselects to populate a table (and "" and making things correct)
Re: Subselects to populate a table
List pgsql-novice
I've read through the docs and I couldn't find many examples of using
subselects.  I could find out and read all about what they were, but not
many examples.  If someone could point to a page that does show this,
I'd be ever so appreciative!
Anyways, I'm redoing a table I imported from MySQL (as part of my
conversion to PG from MySQL) and I'm having problems with this.  The
error I'm getting is that it says you can't select more than one column.
Why?  Is there another way to do what I'm trying?  Here is my query:

INSERT INTO "cards_type_temp"
( "card_game", "card_name", "card_table", "record_num" )
VALUES
( 'Vtes', ( SELECT "card_name", "card_type", "record_num" FROM "cards_type" ));

Any help or insight would be great!

Chris


pgsql-novice by date:

Previous
From: Andrew McMillan
Date:
Subject: Re: How to determine the type of a column
Next
From: "Erwan DUROSELLE"
Date:
Subject: Rép. : Subselects to populate a table