Re: How to keep the last row of a data set? - Mailing list pgsql-general

From Edson Richter
Subject Re: How to keep the last row of a data set?
Date
Msg-id BLU0-SMTP17719E900282A4E5F53DCB3CF4E0@phx.gbl
Whole thread Raw
In response to Re: How to keep the last row of a data set?  (John R Pierce <pierce@hogranch.com>)
List 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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: How to keep the last row of a data set?
Next
From: Tom Lane
Date:
Subject: Re: JDBC to load UTF8@psql to latin1@mysql