Re: Column value derived from generated column in INSERT?

Поиск
Список
Период
Сортировка
Искать
От
Adrian Klaver
Тема
Re: Column value derived from generated column in INSERT?
Дата
Msg-id
507b68d6-db0d-6cc5-f9d3-2dbd7bc8ad97@aklaver.com
Ответ на
Re: Column value derived from generated column in INSERT? (Mark Raynsford)
Список
Дерево обсуждения
Column value derived from generated column in INSERT? Mark Raynsford <co+org.postgresql@io7m.com>
Re: Column value derived from generated column in INSERT? "David G. Johnston" <david.g.johnston@gmail.com>
Re: Column value derived from generated column in INSERT? Mark Raynsford <co+org.postgresql@io7m.com>
Re: Column value derived from generated column in INSERT? Adrian Klaver <adrian.klaver@aklaver.com>
Re: Column value derived from generated column in INSERT? Mark Raynsford <co+org.postgresql@io7m.com>
Re: Column value derived from generated column in INSERT? Adrian Klaver <adrian.klaver@aklaver.com>
Re: Column value derived from generated column in INSERT? Adrian Klaver <adrian.klaver@aklaver.com>
Re: Column value derived from generated column in INSERT? Erik Wienhold <ewie@ewie.name>
Re: Column value derived from generated column in INSERT? "David G. Johnston" <david.g.johnston@gmail.com> 
On 10/19/22 12:48, Mark Raynsford wrote:
> On 2022-10-19T12:43:31 -0700
> Adrian Klaver  wrote:
>>
>> HINT:  There is an entry for table "t", but it cannot be referenced from
>> this part of the query.
>>
>> HINT:  There is a column named "x" in table "t", but it cannot be
>> referenced from this part of the query.
> 
> Yes, I saw those, hence asking on the list if there was a way to do it.

Using a trigger.

> 
> I'll handle it with multiple statements.
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления
Предыдущее
От: Mark Raynsford
Дата:
Следующее
От: Bryn Llewellyn
Дата:
FAQ