Skip site navigation (1) Skip section navigation (2)

Re: Line length in pl/pgsql function

From: Richard Huxton <dev(at)archonet(dot)com>
To: "David Olbersen" <DOlbersen(at)stbernard(dot)com>,<pgsql-sql(at)postgresql(dot)org>
Subject: Re: Line length in pl/pgsql function
Date: 2004-03-17 09:27:50
Message-ID: 200403170927.50757.dev@archonet.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

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

-- 
  Richard Huxton
  Archonet Ltd

In response to

Responses

pgsql-sql by date

Next:From: Gary StainburnDate: 2004-03-17 11:17:16
Subject: Re: working with unix timestamp
Previous:From: Tom LaneDate: 2004-03-17 05:35:47
Subject: Re: Line length in pl/pgsql function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group