On Mon, 2007-10-15 at 12:52 +1000, Brendan Jurd wrote: > On 10/12/07, Simon Riggs <[EMAIL PROTECTED]> wrote: > > I think you should add some examples to show how we would handle an > > INSERT or an UPDATE SET with quite_nullable() and a SELECT WHERE clause > > with quote_literal. The difference is a subtle one, which is why nobody > > mentioned it before, so it needs some better docs too. > > > > A cross-ref to the functions page would help also. > > Alright, I've improved the documentation along the lines suggested by > Simon. There's a full example on doing a null-safe dynamic UPDATE, as > well as a brief discussion about being wary of using comparison > operators with NULLs (e.g., in WHERE clauses). Cross references > abound.
Cool > I did make a version of the patch which has the pg_proc entries for > quote_literal and quote_nullable both pointing to the same internal > function. I thought this was a tidier solution, but it failed > regression test #5 in opr_sanity; apparently two entries in pg_proc > can't have the same prosrc and differing proisstrict? Sanity prevails, I guess. :-) -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly