Re: Line length in pl/pgsql function - Mailing list pgsql-sql

From David Olbersen
Subject Re: Line length in pl/pgsql function
Date
Msg-id E7E213858379814A9AE48CA6754F5ECB0D74A5@mail01.stbernard.com
Whole thread Raw
In response to Line length in pl/pgsql function  ("David Olbersen" <DOlbersen@stbernard.com>)
List pgsql-sql
Richard Huxton wrote:

> On Wednesday 17 March 2004 00:47, David Olbersen wrote:
> >
> > Here's the "clean" code that doesn't work:
> >
> >                 FOR result IN
> >                     SELECT
> >                         initcap( c.name )         AS category,
> >                         initcap( l.language )     AS language,
> >                         count(*)                  AS howmany [etc]
>
> I don't suppose your actual code has any comments in it? I stumbled across an
> obscure parser issue in plpgsql regarding comments/line-endings and I think
> that was somewhere in 7.3.x

That was the actual code. There are comments, but they're one line above that one, and on their own line. Everything is
developedusing Vim on FreeBSD, so line-endings shouldn't be a problem, should they? 

> Might be worth a quick look in the -bugs list archives and see if anything
> looks like your problem.

Didn't see anything on a quick look.

--
David Olbersen
iGuard Engineer
St. Bernard Software
15015 Avenue of Sciences
San Diego, CA 92127
x2152


pgsql-sql by date:

Previous
From: "David Olbersen"
Date:
Subject: Re: Line length in pl/pgsql function
Next
From: Tom Lane
Date:
Subject: Re: Line length in pl/pgsql function