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