Re: How to keep the last row of a data set?

Поиск
Список
Период
Сортировка
От Edson Richter
Тема Re: How to keep the last row of a data set?
Дата
Msg-id BLU0-SMTP17719E900282A4E5F53DCB3CF4E0@phx.gbl
обсуждение исходный текст
Ответ на Re: How to keep the last row of a data set?  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Em 13/12/2012 18:22, John R Pierce escreveu:
> On 12/13/2012 5:32 AM, seiliki@so-net.net.tw wrote:
>> I am trying to implement a mechanism that prohibits the last row of a
>> data set from being deleted.
>>
>> CREATE TABLE t1 (c1 INTEGER,c2 INTEGER, PRIMARY KEY (c1,c2));
>>
>> INSERT INTO t1 VALUES (1,1),(1,2),(1,3),(2,1),(2,2),(2,3);
>
> Which row is the last row?   relations are sets, not ordered lists.
>
>
Last row is not the row that remains, no matter the order?

Edson



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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: How to keep the last row of a data set?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: JDBC to load UTF8@psql to latin1@mysql