Re: calculated default
От | Hitoshi Harada |
---|---|
Тема | Re: calculated default |
Дата | |
Msg-id | 006701c70988$6571fd80$5f01a8c0@daraha обсуждение исходный текст |
Ответ на | calculated default ("SunWuKung" <Balazs.Klein@t-online.hu>) |
Список | pgsql-general |
> I have a table with a sequence as its primary key. > On insert I would like to have all its fields (except the primary key) > default to the last one in the table (order by id desc limit 1). > I guess I should use a trigger to do this but I don't know how. How about this: INSERT INTO table SELECT nextval('seq'), col1, col2... FROM table WHERE pkey = curval('seq'); Regards, Hitoshi Harada > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] On Behalf Of SunWuKung > Sent: Thursday, November 16, 2006 5:48 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] calculated default > > I have a table with a sequence as its primary key. > On insert I would like to have all its fields (except the primary key) > default to the last one in the table (order by id desc limit 1). > I guess I should use a trigger to do this but I don't know how. > > Thanks for the help. > SWK > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match
В списке pgsql-general по дате отправления: