From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | Memphisto <szoli(at)netvisor(dot)hu>, PostgreSQL general mailinglist <pgsql-general(at)postgreSQL(dot)org> |
Subject: | RE: [GENERAL] insert problem. |
Date: | 1998-11-05 18:35:17 |
Message-ID: | F10BB1FAF801D111829B0060971D839F4D72E4@cpsmail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Hi,
>
> I've got this little problem:
> I've got two relations:
> groups(name text); -- This one contains the name of usergroups;
> users (username text, groupid oid, constraint grid primary
> key(username));
> -- The users relation contains the name of the users along with the
> group
> relation's oid as a foreign key.
> I'd like to insert a new user and I also know the group's he or she
> belongs to:
>
> elmu=> insert into users values('Average Joe', (select oid from groups
> where groups.name='grp1'));
> ERROR: parser: parse error at or near "select"
>
> What's wrong with the insertion?
try:
insert into users
select 'Average Joe', oid
from groups
where name = 'grp1';
-DEJ
> Thanks in advance
>
> ----------------------------------------------------------------------
> ----------
> Sebestyén Zoltán AKA Memphisto It all seems so stupid,
> it makes me want to give up.
> szoli(at)netvisor(dot)hu But why should I give up,
> when it all seems so stupid?
>
> MAKE INSTALL NOT WAR And please avoid Necrosoft
> Widows
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1998-11-05 18:47:14 | RE: [GENERAL] age('now',date::datetime) |
Previous Message | A James Lewis | 1998-11-05 18:29:09 | Epoch Time, conversion? |