Re: Using UNION inside a cursor

From: Paul Ganainm <paulsnewsgroups(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Using UNION inside a cursor
Date: 2003-11-04 15:02:57
Message-ID: MPG.1a11c99fb139af0989699@news.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


sgnerd(at)yahoo(dot)com(dot)sg says...

> (SELECT * FROM history WHERE obs_type = \'AA\' )
> UNION
> (SELECT * FROM history WHERE obs_type = \'TA\');

Maybe I'm just confused here, but what's to stop you using

SELECT * FROM History WHERE (Obs_Type = \'AA\' AND Obs_Type = \'TA\')

? Or have I missed something really obvious?

Paul...

--

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jodi Kanter 2003-11-04 15:16:30 query assistance
Previous Message Christoph Haller 2003-11-04 11:18:55 Re: create type input and output function examples