Re: row constructors

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: row constructors
Дата
Msg-id b42b73150902120815g52e8e91bocdd2010a85c54913@mail.gmail.com
обсуждение исходный текст
Ответ на Re: row constructors  (Sim Zacks <sim@compulab.co.il>)
Ответы Re: row constructors  (Rory Campbell-Lange <rory@campbell-lange.net>)
Список pgsql-general
On Thu, Feb 12, 2009 at 5:03 AM, Sim Zacks <sim@compulab.co.il> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Never mind. I found an old post.
> I just needed to do:
> insert into a1 select (f2).* from a2;
>
> I didn't find it the first time I searched because I was looking for row
> constructors, and the post I found used the term composite value.

I'm scheming to get that fixed.  The main reason is that while the
insert workaround works, there is no similar workaround for 'update'.

merlin

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

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: Update table with random values from another table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: covering indexes?