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

subselects

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: 3A259958.D6C578D5@selectacast.net (view raw or flat)
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
field?

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

-- 
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio.  http://www.targabot.com

Responses

  • 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-2014 The PostgreSQL Global Development Group