sql question - Mailing list pgsql-general

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;

For every record in which y is > 1, you get x back.  Otherwise, you get 0
returned.

Thanks,
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------