| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Kirk Wythers <kwythers(at)umn(dot)edu> |
| Cc: | "Luke Lonergan" <llonergan(at)greenplum(dot)com>, "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>, " " Gábriel Ákos " " <akos(dot)gabriel(at)i-logic(dot)hu>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: trouble with a join on OS X |
| Date: | 2007-02-03 03:31:17 |
| Message-ID: | 26885.1170473477@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Kirk Wythers <kwythers(at)umn(dot)edu> writes:
> The new table needs to be filled with the results of the join. If
> there is a way to do this without a SELECT, please share.
If it's an entirely new table, then you probably want to use INSERT
... SELECT. If what you want is to update existing rows using a join,
you can use UPDATE ... FROM (not standard) or something involving a
sub-select. You'd need to state your problem in some detail to get more
help than that...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shane Ambler | 2007-02-03 15:59:49 | Re: trouble with a join on OS X |
| Previous Message | Joshua D. Drake | 2007-02-03 03:25:38 | Re: trouble with a join on OS X |