Re: [GENERAL] Custom Field for a table row returned from stored procedure

2010-01-11 Thread A. Kretschmer
In response to Yan Cheng Cheok : > I have a "lot" table with 2 columns, with one of the column is current > timestamp. > > I try to return another custom fields, which its calculation is based on > timestamp. > > (For simplicity, I include only 1 field in following example) > > CREATE OR REPLA

[GENERAL] Custom Field for a table row returned from stored procedure

2010-01-11 Thread Yan Cheng Cheok
I have a "lot" table with 2 columns, with one of the column is current timestamp. I try to return another custom fields, which its calculation is based on timestamp. (For simplicity, I include only 1 field in following example) CREATE OR REPLACE FUNCTION create_lot(text) RETURNS lot AS $BODY