"Andrus" <[EMAIL PROTECTED]> writes:
> select * from information_schema.key_column_usage
> returns
> ERROR: more than one row returned by a subquery used as an expression
There's a known bug of that ilk in 8.2beta, but I don't see how it could
happen in 8.1 ... you sure you're seeing this on 8.1.1
CSN wrote:
I'm trying to get this query to work:
update sectors set companies =(select companies from
industries where sector_id =sectors.id);
Try these instead:
update sectors
set companies = industries.companies
from industries
where industries.sector_id =sectors.id;
update industrie
On Thu, Oct 13, 2005 at 05:05:56PM -0700, CSN wrote:
> I'm trying to get this query to work:
>
> update sectors set companies =(select companies from industries
> where sector_id =sectors.id);
>
> PG returns:
>
> ERROR: more than one row returned by a subquery used as an
> expression
It's doin
