Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Markus
Subject Re: How to keep the last row of a data set?
Date
Msg-id 50C9F0D1.8020905@proventis.net
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?  (seiliki@so-net.net.tw)
List pgsql-general
Tree view 
Hi,

create an after delete trigger with

IF (SELECT 1 FROM t1 limit 1) is null  THEN
     RAISE EXCEPTION 'Must keep at least 1 row';
  ....


hth
Thomas

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: Re: JDBC to load UTF8@psql to latin1@mysql
Next
From: David Noel
Date:
Subject: initdb error