Received: from p1.selectacast.net (p1.selectacast.net [206.41.1.251]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5LJ4Pa26032 for ; Thu, 21 Jun 2001 15:04:25 -0400 (EDT) (envelope-from jks@selectacast.net) Received: from selectacast.net (IDENT:jks@xtenit.dialup.access.net [166.84.206.91]) by p1.selectacast.net (8.9.3/8.9.3) with ESMTP id PAA17031; Thu, 21 Jun 2001 15:04:12 -0400 Message-ID: <3B324535.FF89D8D0@selectacast.net> Date: Thu, 21 Jun 2001 15:04:21 -0400 From: Joseph Shraibman Organization: Xtenit, Inc. http://www.xtenit.com X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.2.15 i686) X-Accept-Language: en MIME-Version: 1.0 To: Richard Huxton CC: pgsql-sql@postgresql.org Subject: Re: select by streak References: <3B30FB0A.3595CD79@selectacast.net> <00ac01c0fa34$a9948460$1001a8c0@archonet.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/340 X-Sequence-Number: 3627 Richard Huxton wrote: > > From: "Joseph Shraibman" > > > Lets say I have a table like this: > > > > id int <== primary key > > ts timestamp > > name text > > status char > > > > status is G for good or B for bad. How do I do something like: > > SELECT name FROM mytable WHERE > 'B'> and ? > > You're looking at a procedural solution here rather than SQL I'd suspect. > Either do this in your application or look into plpgsql or pltcl. That's what I was afraid of :( -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com