Your patch has been added to the PostgreSQL unapplied patches list at:

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.


Jeremy Drake wrote:
> Since I have now learned that it is possible to input values in hex in
> postgres, I submit this patch to clean up the ugly workaround I did in the
> largeobject regression test to try to input hex values.  It does not
> change the functionality of the test at all, it just makes it more
> readable.
> In detail, before when I needed to write hex values, for example
> 0x20000 | 0x40000,
> for the flags to lo_open, I would write it:
> CAST((2 | 4) * 16^4 AS integer)
> Now, I write it:
> CAST(x'20000' | x'40000' AS integer)
> which is more like the C and other language consumers of the API, and also
> is more obvious what I am trying to do, IMHO.
> -- 
> Real Programs don't use shared text.  Otherwise, how can they use
> functions for scratch space after they are finished calling them?

[ Attachment, skipping... ]

> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?

  Bruce Momjian  <[EMAIL PROTECTED]>

  + If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to