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 (as if the

Re: [GENERAL] automatic value conversion

2007-03-24 Thread 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 (as if the table had a text colum) You woul

[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