From: | Mathew White <guru(at)fundgroup(dot)com> |
---|---|
To: | "'dgreer(at)websightsolutions(dot)com'" <dgreer(at)websightsolutions(dot)com>, "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | RE: [SQL] Trouble with insert into. |
Date: | 1999-06-18 14:24:11 |
Message-ID: | 01BEB963.F2504400.guru@fundgroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi. I'm new to mailing lists, so let me know if I don't post
properly.
Here is an SQL statement that I found that works for what you are
doing (your own SQL statement was very close). Note the text
conversion for the zip field.
insert into tableB
select l.username, '4-15-1999', l.zip::text
from tableA l
where not exists (
select ld.username
from tableB ld
where ld.username = l.username
)
;
On Friday, June 18, 1999 5:38 AM, Darren Greer
[SMTP:dgreer(at)websightsolutions(dot)com] wrote:
> Hello all. Lets say I have:
> Table A (username text, first_name text, last_name text, zip int4)
> Table B (username text, signupdate date, zip text)
>
> In table A I have
> user1 fred jones 53125
> user2 bob smith 52145
>
> In table B I have
> user2 06/16/1999 52145
>
> The way these tables were populated, table A and B were written to
> at the same
> time. However, table B, did not exist for the first 6 months of
> use. So there
> are many users who are in table A, that are not in table B.
>
> Now what I am tryign to do, is insert all users that dont exist in
> table B,
> that exist in table A, into table B. With o ne twist. Signup date
> does not
> exist in table A, so I need to insert them all with an arbitrary
> date. I plan
> on putting them all in as 04/15/1999.
>
> Here is the select statement I was able to get to work:
> select l.username, l.zip
> from tableA l
> where not exists (
> select ld.username
> from tableB ld
> where ld.username = l.username
> );
>
> Now my difficulty comes in inserting the data that is retrieved
into
> table B.
>
> If anyone can help me out, I would greatly appreciate it.
>
> Thanks,
>
> Darren
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1999-06-18 15:16:47 | RE: [SQL] Join operations |
Previous Message | Darren Greer | 1999-06-18 11:38:25 | Trouble with insert into. |