| From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Wayne Armstrong <wdarmst(at)bacchus(dot)com(dot)au>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: insert aliases? |
| Date: | 2003-03-18 15:47:44 |
| Message-ID: | 1048002464.1058.7.camel@coppola.ecircle.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> "Wayne Armstrong" <wdarmst(at)bacchus(dot)com(dot)au> writes:
> > It seems that postgress doesn't accept aliases for the tablename in updates,
> > inserts, and deletes as it does do for selects ????
>
> Nope, and neither does the SQL standard ...
>
But it would be VERY useful for the UPDATE command... Postgres has that
nice extension of multi-table where clause for updates, but it can be
confusing when you want to specify the updated table for a self-join.
Being able to alias the updated table too would make things cleaner.
Cheers,
Csaba.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-03-18 16:10:20 | Re: MS SQL 2K replication/backup |
| Previous Message | u15074 | 2003-03-18 15:23:14 | Causes an insert into a table with a unique column a tablelock or a rowlock? |