Subselects to populate a table
От | Chris Boget |
---|---|
Тема | Subselects to populate a table |
Дата | |
Msg-id | 003701c2b32b$9f521ec0$8c01a8c0@ENTROPY обсуждение исходный текст |
Ответ на | How to determine the type of a column ("Ville Jungman" <ville_jungman@hotmail.com>) |
Ответы |
Re: Subselects to populate a table (and "" and making things correct)
Re: Subselects to populate a table |
Список | 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 по дате отправления: