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

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: > http://www

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: http://www.postgresql.org/docs/8.2/interactive/sql-createtable.htm

[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 broadcast)--