Re: [GENERAL] nested elseif woes
On Tue, May 11, 2004 at 12:58:55AM +0200, Ivan Sergio Borgonovo wrote: > thanks to everyone. > Curiously enough, trying to figure out what was wrong with my code, > I've been able to write versions with the wrong spelling that didn't > complain. That brought me astray. > > Anyway does anyone know any public big enough project written in > plpgsql from which I could learn lurking at the code? OpenACS (from openacs.org) is a huge web application framework with the vast majority of the business logic written in PL/SQL. It has a wide selection of PL/SQL functions, with equivalents for both Oracle and PostgreSQL. Cheers, Steve ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] nested elseif woes
On Mon, 10 May 2004 13:56:39 -0500 (EST) Kris Jurka <[EMAIL PROTECTED]> wrote: > On Mon, 10 May 2004, Ivan Sergio Borgonovo wrote: > > > Now let's come to the problem: > > > > create or replace function testa( ) > > returns char(32) as > > ' > > begin > > if 1=2 then > > if 1=2 then > > select 1; > > elseif 1=3 then > > select 2; > > elseif 1=4 then > > Don't you mean ELSIF, not ELSEIF? thanks to everyone. Curiously enough, trying to figure out what was wrong with my code, I've been able to write versions with the wrong spelling that didn't complain. That brought me astray. Anyway does anyone know any public big enough project written in plpgsql from which I could learn lurking at the code? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
