[PATCHES] pgcrypto BYTE_ORDER fix for stable branches

Recently was uncovered that pgcrypto does not include right header file to get BYTE_ORDER define on Cygwin and MINGW, and the missing define does not result in build failures, but random combinations of little and big-endian code sections. This patch adds missing sys/param.h include for md5.c, sha

[PATCHES] Final cleanup of SQL:1999 references

This doc patch replaces all inappropriate references to SQL:1999 when it is used as if it were the latest (and/or still valid) SQL standard. SQL:2003 is used in its place. Best Regards, Simon Riggs Index: array.sgml === RCS file: /p

[PATCHES] PL/PGSQL: Dynamic Record Introspection

Hi all, I needed introspection capabilities for record types to write more generic trigger procedures in PL/PGSQL. With the following patch it's possible to - extract all field names of a record into an array - extract field count of a record - address a single field of a record with a variable

[PATCHES] A minor patch to mark xml/xslt functions immutable

Immutability is obvious, because xml procession result depends on the document and request solely. Couldn't use it for indexes w/o that flag. --- /root/pgxml.sql.in Sat Jul 9 21:41:33 2005 +++ /usr/ports/databases/postgresql-contrib/work/postgresql-8.0.3/contrib/xml2/p gxml.sql.in Sat Ju

Re: [PATCHES] PL/PGSQL: Dynamic Record Introspection

Titus von Boxberg wrote: With the following patch it's possible to - extract all field names of a record into an array - extract field count of a record - address a single field of a record with a variable containing the field name (additional to the usual record.fieldname notation where the

Re: [PATCHES] Final cleanup of SQL:1999 references

Simon Riggs wrote: This doc patch replaces all inappropriate references to SQL:1999 when it is used as if it were the latest (and/or still valid) SQL standard. Applied, thanks. -Neil ---(end of broadcast)--- TIP 4: Have you searched our list arc

Re: [PATCHES] PL/PGSQL: Dynamic Record Introspection

good idea. it's what can eliminate not neccessery using plperl. I would to see it in plpgsql. regards Pavel On Thu, 14 Jul 2005, Titus von Boxberg wrote: > Hi all, > > I needed introspection capabilities for record types to write more generic > trigger procedures in PL/PGSQL. > > With the fol

Re: [PATCHES] thousands comma numeric formatting in psql

Thanks, fixed, and applied. I also centralized the malloc into a function. We could use pg_malloc, but that doesn't export out to /scripts, where this is shared. We will fix that some day, but not right now. --- Eugen Ned