Re: PL/pgSQL 1.2

Поиск
Список
Период
Сортировка
От Shaun Thomas
Тема Re: PL/pgSQL 1.2
Дата
Msg-id 5408728D.30902@optionshouse.com
обсуждение исходный текст
Ответ на Re: PL/pgSQL 1.2  (Hannu Krosing <hannu@2ndQuadrant.com>)
Ответы Re: PL/pgSQL 1.2  (Marko Tiikkaja <marko@joh.to>)
Список 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@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Escaping from blocked send() reprised.
Следующее
От: Marko Tiikkaja
Дата:
Сообщение: Re: PL/pgSQL 1.2