From: | "Wm(dot) G(dot) Urquhart" <wgu(at)wurquhart(dot)co(dot)uk> |
---|---|
To: | PostgreSQL General Forum <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: More on "What am I doing wrong!" |
Date: | 2002-05-19 08:56:44 |
Message-ID: | Pine.LNX.4.44.0205190953530.510-100000@mailer.wurquhart.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, 18 May 2002, mordicus wrote:
> I found another problem with your plpgsql function in apply_parent_details,
>
> UPDATE "Parents" SET "MTitle" = ptitle, "MForename" = pforename, "MSurname" =
> psurname, "Addr1" = addr1, "Addr2" = addr2, "Addr3" = addr3, "Town" = town,
> "Postcode" = postcode, "TelNo1" = telno1, "TelNo2" =(at)telno2, "eMail" = email
>
> "TelNo2" =(at)telno2 ??? should be juste telno2, no ?
Yes you are correct, but this code is never called in this context.
However, all the statements have since been changes and now use $n.
> Another thing, if possible, don't use oid, use sequence instead, more
> reliable.
Ok, I'll change it.
> And when you declare your function, don't use "iscachable" option since this
> type of function is not cacheable, it can cause some probs.
It's not! Well I consider this a prime candidate for caching. Oh well.
> And, last thing, sorry for my bad english :)
:-)
>
--
Regards,
Wm. G. Urquhart
Custom Software Solutions
http://www.wurquhart.co.uk
From | Date | Subject | |
---|---|---|---|
Next Message | Patrice Hédé | 2002-05-19 09:44:13 | Re: [HACKERS] UTF-8 safe ascii() function |
Previous Message | Wm. G. Urquhart | 2002-05-19 08:53:25 | Re: More on "What am I doing wrong!" |