From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
---|---|
To: | Hannu Krosing <hannu(at)2ndQuadrant(dot)com>, Marko Tiikkaja <marko(at)joh(dot)to>, Bruce Momjian <bruce(at)momjian(dot)us>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Joel Jacobson <joel(at)trustly(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PL/pgSQL 1.2 |
Date: | 2014-09-04 14:09:17 |
Message-ID: | 5408728D.30902@optionshouse.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 09/03/2014 04:19 PM, Hannu Krosing wrote:
> 1. Conditions for number of rows returned by SELECT or touched by
> UPDATE or DELETE
Now that I think upon this... don't we already have it?
SELECT ... LIMIT 1
That already solves the purported problem of multiple results in SELECT
INTO as well. Could we possibly extend that to UPDATE and DELETE syntax too?
--
Shaun Thomas
OptionsHouse, LLC | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Tiikkaja | 2014-09-04 14:12:48 | Re: PL/pgSQL 1.2 |
Previous Message | Robert Haas | 2014-09-04 13:57:14 | Re: Escaping from blocked send() reprised. |