[GENERAL] PL/PGSQL rowtype return problem

2007-06-12 Thread rwickert
Hi, I have a problem when I create a function that returns a rowtype. I can't access the individual fields of that rowtype from another function if I put the results in a row type variable. I'm inserting many records into a table (let's say, insert_table). This table has a trigger on it since I

Re: [GENERAL] PL/PGSQL rowtype return pr

2007-06-12 Thread rwickert
Hi, Yes that works but when I try to put the results of a rowtype returning function into a rowtype variable in another function i cannot access the individual attributes from variable. Only from the direct call. ie. x1 := (get_defaults_vals()).a1 x2 := (get_defaults_vals()).a2 x3 := (get_de

Re: [GENERAL] PL/PGSQL rowtype return pr

2007-06-12 Thread rwickert
That worked. Thank you very much. -Original Message- From: [EMAIL PROTECTED] Sent: 12 June 2007 16:41 To: Robert Wickert Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] PL/PGSQL rowtype return pr --

[GENERAL] Recall: August Monthly techdata split fi

2007-09-18 Thread rwickert
Robert Wickert would like to recall the message, "August Monthly techdata split file printers for France and Denmark ". * Robert Wickert Senior Software Developer CONTEXT Tel:+44 (0)20 8394 7739 Fax:+44 (0)20 8394 7701 Email Address: [EMAIL PRO

[GENERAL] FW: August Monthly techdata split file p

2007-09-18 Thread rwickert
ok they're both done -Original Message- From: Robert Wickert Sent: 18 September 2007 11:05 To: Gurvan Meyer Subject: RE: August Monthly techdata split file printers for France and Denmark the reports can always be found here .. \\147.114.32.180\monthly_sales_reports\ just find the yea