Re: [PATCHES] Small plperl documentation patch

2005-10-19 Thread Andrew Dunstan
Greg Sabino Mullane wrote: Tom Lane asked: Please, tell me that isn't so. $a is a reserved name now? What was Larry thinking? It's not that bad, really. $a and $b have special meaning inside of a sort subroutine as the two items being compared. Thus, you can write something like

[PATCHES] Error in ORDER BY on check constraints in psql

2005-10-19 Thread Christopher Kings-Lynne
Everything is sorted by object name in \d except check constraints for some reason. It seems it's ordering by the wrong column. Seems like a bug to me. Attached is the trivial patch. Chris Index: src/bin/psql/describe.c === RCS

Re: [PATCHES] Error in ORDER BY on check constraints in psql

2005-10-19 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > Everything is sorted by object name in \d except check > constraints for some reason. It seems it's ordering by the wrong column. > Seems like a bug to me. That was probably done deliberately, back in the day when constraints tended to have

Re: [PATCHES] Error in ORDER BY on check constraints in psql

2005-10-19 Thread Christopher Kings-Lynne
That was probably done deliberately, back in the day when constraints tended to have uselessly random names like "$1" --- sorting by the constraint text was more helpful. I agree that now sorting by name seems like the better thing. Even in the "$x" case, it's better to have them sorted in that

Re: [PATCHES] Caveat for Domains

2005-10-19 Thread David Fetter
On Thu, Sep 22, 2005 at 07:57:35PM -0400, Bruce Momjian wrote: > Patch applied. Thanks. Could you please put fixing domains for functions on the TODO list? Cheers, D > > --- > > > David Fetter wrote: > > Folks, > > > >