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

Re: [despammed] sql can i substitute

From: Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>
To: Andreas Kretschmer <akretschmer(at)despammed(dot)com>,pgsql-sql(at)postgresql(dot)org
Subject: Re: [despammed] sql can i substitute
Date: 2004-12-17 13:01:18
Message-ID: 0412171831181R.06834@thenilgiris.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Friday 17 December 2004 05:54 pm, Andreas Kretschmer wrote:

> Yes, simple:
>
> test=# select name,  case
> test-# when fruit = 1 then 'good'
> test-# when fruit = 2 then 'bad'
> test-# when fruit = 3 then 'rotten' end as fruit from fruit;

can one do the same thing for an 'insert' statement?

kg

In response to

Responses

pgsql-sql by date

Next:From: Achilleus MantziosDate: 2004-12-17 14:08:53
Subject: Re: [despammed] sql can i substitute
Previous:From: Kenneth GonsalvesDate: 2004-12-17 12:52:48
Subject: Re: sql can i substitute

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