Re: Line length in pl/pgsql function

From: "David Olbersen" <DOlbersen(at)stbernard(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Line length in pl/pgsql function
Date: 2004-03-17 19:52:05
Message-ID: E7E213858379814A9AE48CA6754F5ECB0D74A5@mail01.stbernard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 developed using 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

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-03-17 20:03:01 Re: Line length in pl/pgsql function
Previous Message David Olbersen 2004-03-17 19:50:44 Re: Line length in pl/pgsql function