Subqueries in Non-SELECT Queries

Поиск
Список
Период
Сортировка
От Frank Joerdens
Тема Subqueries in Non-SELECT Queries
Дата
Msg-id 3A3CFFF9.3615E576@joerdens.de
обсуждение исходный текст
Ответы Re: Subqueries in Non-SELECT Queries  (Christof Glaser <gcg@gl.aser.de>)
Re: Subqueries in Non-SELECT Queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
I am trying to do something that looks to me exactly like what's described in chapter 8.4
in the Postgresql book:

test=> UPDATE salesorder
test-> SET ship_date = '11/16/96'
test-> WHERE customer_id = (
test(> SELECT customer_id
test(> FROM customer
test(> WHERE name = 'Fleer Gearworks, Inc.'
test(> );
UPDATE 1

Here only one row is updated. This should work with more than one, right? I get an error
which suggests that it doesn't:

mpi=# update index set level = 2 where parentid = ( select id from index where level = 1
);
ERROR:  More than one tuple returned by a subselect used as an expression.
mpi=#

This is a recursive query, on a single table. Is that not possible?

I am using 7.1.

- Frank


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

Предыдущее
От: "Albert REINER"
Дата:
Сообщение: Re: Documentation for CASE
Следующее
От: Christof Glaser
Дата:
Сообщение: Re: Subqueries in Non-SELECT Queries