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

RE: Iterations in a SELECT

From: Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)de>
To: pgsql-novice(at)postgresql(dot)org, Scott Muir <wsmuir(at)islandnet(dot)com>
Subject: RE: Iterations in a SELECT
Date: 2001-07-18 03:05:11
Message-ID: Pine.LNX.4.21.0107180501040.26292-100000@lothlorien.stunet2.tu-freiberg.de (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, 17 Jul 2001, Scott Muir wrote:
> Thank you...  Your suggestion is how I am doing it until a better suggestion
> comes along, but without building a dynamic sql statement with many UNION
> statements (read: mess), I can't think of how to build a non-table-driven
> multi-row query result...

depending on the number of values you would like to compare, you can use
something like

	select value from foo where value in (1,2,3,4,5)

have fun,

helge


In response to

pgsql-novice by date

Next:From: tamsinDate: 2001-07-18 08:17:39
Subject: RE: Iterations in a SELECT
Previous:From: Scott MuirDate: 2001-07-18 02:49:36
Subject: RE: Iterations in a SELECT

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