Re: Function Hangs

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Function Hangs
Date: 2002-02-13 05:45:33
Message-ID: web-692496@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Patrick,

Oh, and take out this BEGIN and END marker, it's confusing the parser:

> begin
<snip>
> update ozpricing set useascurrprice = 0 where
> keyp_priceschedule = myRec.keyp_priceschedule;
> v_count = v_count + 1;
> end;

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Nebojsa Pirocanac 2002-02-13 09:33:53 Number of connection
Previous Message Josh Berkus 2002-02-13 05:43:31 Re: Function Hangs