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

Re: Standard syntax?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Franz J Fortuny <ffortuny(at)ivsol(dot)com>
Cc: sqllist <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Standard syntax?
Date: 2000-10-12 18:45:55
Message-ID: Pine.LNX.4.21.0010122044470.12683-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-sql
Franz J Fortuny writes:

> select col1,
>      case when col2 = true then
>         col3
>      else
>         col4
>      end as colw,
>     colM
> where .... etc.

> is this a "standard" or ANSI 9X compatible syntax

Yes.

-- 
Peter Eisentraut      peter_e(at)gmx(dot)net       http://yi.org/peter-e/


In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2000-10-12 19:32:26
Subject: Re: Standard syntax?
Previous:From: John McKownDate: 2000-10-12 18:37:09
Subject: Re: if else query help

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