Re: Function not running after upgrade 7.03 to 7.2

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <juerg(dot)rietmann(at)pup(dot)ch>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Function not running after upgrade 7.03 to 7.2
Date: 2002-06-14 08:20:31
Message-ID: GNELIHDDFBOCMGBFGEFOMEMECCAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> Query :
>
> SELECT *,
> (SELECT rtrim(buildUmfang(zylinder.z_typ), ','::text) AS rtrim) AS umfang
> FROM zylinder;
>
> Thank's in advance for any help .... jr

Try this:

SELECT *,
(SELECT rtrim("buildUmfang"(zylinder.z_typ), ','::text) AS rtrim) AS umfang
FROM zylinder;

I think it's because you have an upper case letter in the name - you might
need to quote it.

Chris

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2002-06-14 13:40:43 ON DELETE CASCADE question
Previous Message juerg.rietmann 2002-06-14 08:11:28 Function not running after upgrade 7.03 to 7.2