[GENERAL] automatic value conversion

2007-03-24 Thread Sebastian Boehm
Hi, currently I do this: INSERT INTO table1 (row1) VALUES ( function_in('argument1','myvalue')) and select function_out('argument1',row1) from table1; (which gives 'myvalue' again) funtion_out(text,int) returns text funtion_in(text,text) returns int the table looks like this: create table

Re: [GENERAL] automatic value conversion

2007-03-24 Thread Sebastian Boehm
Am 24.03.2007 um 19:08 schrieb Tom Lane: Sebastian Boehm <[EMAIL PROTECTED]> writes: the functions function_in and function_out should be called automatically on select or insert / update. How can I change the table definition to use function_in and function_out transparently for me

[GENERAL] performance of fixed length columns-only tables

2007-03-28 Thread Sebastian Boehm
Hi, is there an advantage of using fixed length columns only in a table ? /sebastian ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq