Possible feature request

Поиск
Список
Период
Сортировка
От Brian Hurt
Тема Possible feature request
Дата
Msg-id 46A7A3D4.6090206@janestcapital.com
обсуждение исходный текст
Ответы Re: Possible feature request
Список pgsql-hackers
I'm not sure if this is the right venue for this- if it isn't, I apologize.

But a feature that I'd like to see is the ability to put an 'as' alias 
on the target of an update statement.

I find myself often writing statements like:   UPDATE      some_really_long_table_name   SET      col1 = some_value,
 col2 = some_other_value   FROM      some_other_really_long_table_name AS table2   WHERE
some_really_long_table_name.col3= table2.col3      AND some_really_long_table_name.col4 = table2.col4   ;
 

What I'd like to write is:   UPDATE      some_really_long_table_name AS table1   SET      col1 = some_value,      col2
=some_other_value   FROM      some_other_really_long_table_name AS table2   WHERE      table1.col3 = table2.col3
ANDtable1.col4 = table2.col4   ;
 

Is this possible?  Not for 8.3, obviously, but maybe for 8.4?

Brian



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: Machine available for community use
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: Machine available for community use