"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
select * from information_schema.key_column_usage
returns
ERROR: more than one row returned by a subquery used as an expression
SQL state: 21000
How to reconstruct primay and foreign key statements ?
Andrus.
"PostgreSQL 8.1.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-spec
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
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
Column companies is just a count of rows in the
related companies table. Queries
