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

From John R Pierce
Subject Re: How to keep the last row of a data set?
Date
Msg-id 50CA3919.1090208@hogranch.com
Whole thread Raw
In response to How to keep the last row of a data set?  (seiliki@so-net.net.tw)
Responses Re: How to keep the last row of a data set?  (Edson Richter <edsonrichter@hotmail.com>)
Re: How to keep the last row of a data set?  (Chris Angelico <rosuav@gmail.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: XML Schema for PostgreSQL database
Next
From: Edson Richter
Date:
Subject: Re: How to keep the last row of a data set?