Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by hub.org (8.10.1/8.10.1) with ESMTP id e6CNPZW83770 for ; Wed, 12 Jul 2000 19:25:35 -0400 (EDT) Received: by rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-general@postgresql.org; Wed, 12 Jul 2000 18:25:35 -0500 (CDT) Date: Wed, 12 Jul 2000 18:25:35 -0500 From: "Ross J. Reedstrom" To: pgsql-general@postgresql.org Subject: Re: sql question Message-ID: <20000712182535.A6848@rice.edu> Mail-Followup-To: pgsql-general@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: ; from trbauer@indiana.edu on Wed, Jul 12, 2000 at 05:33:09PM -0500 X-Archive-Number: 200007/532 On Wed, Jul 12, 2000 at 05:33:09PM -0500, Travis Bauer wrote: > > Let's say I have a table t1 with two fields, x and y. How do I write an > sql statement like: > > select x if y>1 else 0 from t1; SELECT CASE WHEN y>1 THEN x ELSE 0 END FROM t1;