From: | Timothy Smith <timothy(at)open-networks(dot)net> |
---|---|
To: | |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | unsubscribe |
Date: | 2005-08-09 22:31:50 |
Message-ID: | 42F92ED6.4010207@open-networks.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org)
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Owen Jacobson | 2005-08-09 22:39:33 | Faster count(*)? |
Previous Message | daq | 2005-08-09 13:58:57 | Re: [NOVICE] Suspend Referential Integrity? |