Skip site navigation (1) Skip section navigation (2)


From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: subselects
Date: 2000-11-30 00:03:36
Message-ID: (view raw or whole thread)
Lists: pgsql-sql
I tried to do this:
 SELECT r , a , (SELECT u , re FROM dir WHERE u = a) , cdate FROM rep
WHERE m IN(190);

... and I got:

ERROR:  Subselect must have only one field

An explain shows that two subselects result in two queries, even thought
they are accessing the same row.  Why can subselects only have one

Database version: PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc

Joseph Shraibman
Increase signal to noise ratio.


  • Re: subselects at 2000-12-02 10:27:23 from hubert depesz lubaczewski

pgsql-sql by date

Next:From: Joel BurtonDate: 2000-11-30 00:07:57
Subject: Re: Cache look up failure
Previous:From: Joel BurtonDate: 2000-11-30 00:00:22
Subject: Rules with Conditions: Bug, or Misunderstanding

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group