Transform groups

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Transform groups
Date: 2003-04-29 17:58:48
Message-ID: Pine.LNX.4.44.0304291736590.2161-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

There was some talk in the context of the new protocol to do some
enhancements in the area of the "binary" format to make it useful across
different architectures etc.

The SQL standard defines a concept called "transform groups", which are
basically pairs of input/ouput functions that can be switched between.
The standard talks about different transform groups for different host
languages, so this essentially selects between different binary output
formats.

I think this would fit naturally with many things we are doing and want to
do. We could have a (default) "text" transform group, a "binary little
endian" transform group, a "binary big endian" transform group".
Transform groups could map more sophisticated data types into native
programming language structures (think timestamp or inet). Users could
also plug in their own transform groups for existing data types if they
hate the input or output format. It would also reduce the pressure to add
more ad-hoc format-twiddling parameters like extra_float_digits or even
datestyle.

Is this something worth investigating?

--
Peter Eisentraut peter_e(at)gmx(dot)net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jason Tishler 2003-04-29 18:14:32 Cygwin PostgreSQL CVS build issues
Previous Message Tom Lane 2003-04-29 16:45:37 Re: Problem with COPY on RedHat 8 with PostgreSQL 7.3.2

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2003-04-29 19:34:36 Re: Transform groups
Previous Message Haron, Charles 2003-04-29 17:12:49 User-defined functions with Kylix/Delphi