Postgres Pro
Downloads
Home   >   mailing lists

Select in update - Mailing list pgsql-general

From João" Paulo Batistella
Subject Select in update
Date
Msg-id 20020708193523.75799.qmail@web21203.mail.yahoo.com
Whole thread Raw
Responses Re: Select in update
Re: Select in update
List pgsql-general
Tree view 
Hello!

I need to update a table (13000 rows) using something
like this:
update rua  set cod_bairro =
(select cod_bairro from bairro b where b.vetbairro =
r.vetbairro)

Is it possible?? Can I use a select statement as input
for an update??

Thanks,
JP


__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com

pgsql-general by date:

Previous
From: nconway@klamath.dyndns.org (Neil Conway)
Date:
Subject: Re: PostgreSQL doesn't use indexes even is enable_seqscan = off
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: Odd new symptom - database locking up on a query