Home > mailing lists

switch statement in plpgsql - Mailing list pgsql-novice

From	Godshall Michael
Subject	switch statement in plpgsql
Date	July 29, 2003 16:21:06
Msg-id	A596FA3368757645AF862C701495CA000138CB74@hor1mspmx01.gmachs.com Whole thread Raw
Responses	Re: switch statement in plpgsql (Robert Treat <xzilla@users.sourceforge.net>)
List	pgsql-novice

Hello,

Is it possible to use a case switch statement in a plpgsql function or must I use If-Else statements only?

If so what is the format?

I have tried the following which when compiled is accepted but when I call the function it crashes.

switch(tregion)

{

case : ''San Ramon'' then tregion := ''San Ramon, CA'';

break;

}

From: Dmitry Tkach
Date: 29 July 2003, 16:12:29
Subject: Re: help: now() + N is now failing!

From: Tom Lane
Date: 29 July 2003, 16:26:21
Subject: Re: help: now() + N is now failing!