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

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to keep the last row of a data set?
Date: 2012-12-13 21:00:09
Message-ID: BLU0-SMTP17719E900282A4E5F53DCB3CF4E0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em 13/12/2012 18:22, John R Pierce escreveu:
> On 12/13/2012 5:32 AM, seiliki(at)so-net(dot)net(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-12-13 21:13:27 Re: JDBC to load UTF8@psql to latin1@mysql
Previous Message John R Pierce 2012-12-13 20:22:49 Re: How to keep the last row of a data set?