Re: Simple SQL question, need help.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: fyzfeech(at)yahoo(dot)com (feech)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Simple SQL question, need help.
Date: 2001-05-28 16:20:00
Message-ID: 13188.991066800@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

fyzfeech(at)yahoo(dot)com (feech) writes:
> INSERT INTO results (PlayerID, Position) values (SELECT players.id
> from players WHERE name = 'Chuck', 4 );

You need to put parentheses around the sub-select used as an
expression:

INSERT INTO results (PlayerID, Position) values ((SELECT players.id
from players WHERE name = 'Chuck'), 4 );

A more conventional way to get the same result is

INSERT INTO results (PlayerID, Position)
SELECT id, 4 FROM players WHERE name = 'Chuck';

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Linh Luong 2001-05-28 16:23:36 Seq Scan
Previous Message Tom Lane 2001-05-28 16:14:12 Re: set datestyle