Re: [HACKERS] a proposal for an extendable deparser

2009-02-26 Thread Dave Gudeman
iners to know yet another language. The upside is that they let you work at a higher level of abstraction. And most of them come with built-in pretty printers :-). On Thu, Feb 26, 2009 at 11:54 AM, Tom Lane wrote: > Dave Gudeman writes: > > I would replace this with a table-driven d

[HACKERS] a proposal for an extendable deparser

2009-02-26 Thread Dave Gudeman
While writing a shared-library extension for Postgres, I needed to output SQL expressions from trees. The only facility for doing that seems to be the deparse code in ruleutils.c, which is really intended for outputing rules and constraints, not for producing general SQL, so it didn't do quite what

Re: [HACKERS] Handling NULL records in plpgsql

2008-10-25 Thread Dave Gudeman
On Sat, Oct 25, 2008 at 11:59 AM, Robert Haas <[EMAIL PROTECTED]> wrote: > > I really think we should have a way of telling if a array/row/record > > variable is actually set to something, and I'm pretty sure that should be > > unrelated to whether all the elements in it happen to be null. > > +1.

Re: [HACKERS] PGDay.it collation discussion notes

2008-10-22 Thread Dave Gudeman
On Mon, Oct 20, 2008 at 2:28 AM, Heikki Linnakangas < [EMAIL PROTECTED]> wrote: > Tom Lane wrote: > >> Another objection to this design is that it's completely unclear that >> functions from text to text should necessarily yield the same collation >> that went into them, but if you treat collation

[HACKERS] adding collation to a SQL database

2008-10-18 Thread Dave Gudeman
Normally I would lurk on this list for a month or two before I considered posting, but I saw a note on collation and thought some of you might be interested in my experience implementing collation for the ANTs Data Server. In ADS, we treated the collation internally as part of the type for string