Re: [GENERAL] Column Default Clause and User Defined Functions

2007-06-28 Thread Michael Glaesemann
On Jun 28, 2007, at 0:01 , Tom Lane wrote: Whether that is a good idea is another question entirely ... it seems a bit questionable, but on the other hand time-varying defaults like default now() have time-honored usefulness, so I'm not quite sure why I feel uncomfortable with it. I thought

[GENERAL] Column Default Clause and User Defined Functions

2007-06-27 Thread Keary Suska
Is it possible to have a user-defined function (a plpqsql function) as the argument to a default clause that issues SELECTs on other tables? Thanks, Keary Suska Esoteritech, Inc. Demystifying technology for your home or business ---(end of

Re: [GENERAL] Column Default Clause and User Defined Functions

2007-06-27 Thread Michael Glaesemann
On Jun 27, 2007, at 18:18 , Keary Suska wrote: Is it possible to have a user-defined function (a plpqsql function) as the argument to a default clause that issues SELECTs on other tables? Not according to the documentation:

Re: [GENERAL] Column Default Clause and User Defined Functions

2007-06-27 Thread Tom Lane
Michael Glaesemann [EMAIL PROTECTED] writes: On Jun 27, 2007, at 18:18 , Keary Suska wrote: Is it possible to have a user-defined function (a plpqsql function) as the argument to a default clause that issues SELECTs on other tables? Not according to the documentation: