unsubscribe - Mailing list pgsql-sql

From Timothy Smith
Subject unsubscribe
Date
Msg-id 42F92ED6.4010207@open-networks.net
Whole thread Raw
In response to postgresql 8.01, plpgsql  (Timothy Smith <timothy@open-networks.net>)
List pgsql-sql
Timothy Smith wrote:

> i have the following function in plpgsql giving stynax errors all over 
> the place.
> i have doen createlang on the db, as far as i can see i'm right.  is 
> there anything obviously wrong?
> one thing to note is i followed this example 
> http://www.zigo.dhs.org/postgresql/#insert_or_update and it gives the 
> same errors.
>
> "ERROR:  unterminated dollar-quoted string at or near "$$
> BEGIN
> LOOP"
>
>
> CREATE OR REPLACE FUNCTION insert_update_daily_takings (ID BIGINT,
>                                                        TillName VARCHAR,
>                                                        Tape 
> NUMERIC(10,2),
>                                                        Cash 
> NUMERIC(10,2),
>                                                        GM NUMERIC(10,2),
>                                                        VenueManager 
> NUMERIC(10,2),
>                                                        AsstManager 
> NUMERIC(10,2),
>                                                        BarManager 
> NUMERIC(10,2),
>                                                        PRCards 
> NUMERIC(10,2),
>                                                        otherPromo 
> NUMERIC(10,2),
>                                                        Functions 
> NUMERIC(10,2),
>                                                        Accounts 
> NUMERIC(10,2),
>                                                        Spill 
> NUMERIC(10,2),
>                                                        Orings 
> NUMERIC(10,2),
>                                                        Variance 
> NUMERIC(10,2)
> ) RETURNS VOID AS
> $$
> BEGIN
>    LOOP
>        UPDATE daily_takings SET till_name = TillName,
>                tape = Tape,
>                cash = Cash,
>                promo_manager = GM,
>                venue_manager = VenueManager,
>                asst_manager = AsstManager,
>                bar_manager = BarManager,
>                pr_cards = PRCards,
>                other_promo = otherPromo,
>                functions = Functions,
>                accounts = Accounts,
>                spill = Spill,
>                o_rings = Orings,
>                variance = Variance
>                WHERE id = ID
>                 AND till_name = TillName;
>        IF found THEN
>            RETURN;
>        END IF;
>              BEGIN
>            INSERT INTO daily_takings (id,
>                till_name,
>                tape,
>                cash,
>                promo_manager,
>                venue_manager,
>                asst_manager,
>                bar_manager,
>                pr_cards,
>                other_promo,
>                functions,
>                accounts,
>                spill,
>                o_rings,
>                variance)
>            VALUES (ID,
>                    TillName,
>                    Tape,
>                    Cash,
>                    GM,
>                    VenueManager,
>                    AsstManager,
>                    BarManager,
>                    PRCards,
>                    otherPromo,
>                    Functions,
>                    Accounts,
>                    Spill,
>                    Orings,
>                    Variance);
>            RETURN;
>        EXCEPTION WHEN unique_violation THEN
>            NULL
>        END;
>    END LOOP;
> END;
> $$
> LANGUAGE plpgsql;
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>



pgsql-sql by date:

Previous
From: daq
Date:
Subject: Re: [NOVICE] Suspend Referential Integrity?
Next
From: "Owen Jacobson"
Date:
Subject: Faster count(*)?