Re: column_info()'s COLUMN_DEF values - literal vs function

2009-05-28 Thread Tim Bunce
On Wed, May 27, 2009 at 05:04:04PM +0200, H.Merijn Brand wrote: The ODBC 3.0 spec says http://web.archive.org/web/20070513203826/http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlcolumns.asp The default value of the column. The value in this column should be interpreted as

Re: column_info()`s COLUMN_DEF values - literal vs function

2009-05-28 Thread Tim Bunce
On Wed, May 27, 2009 at 03:10:53PM -, Greg Sabino Mullane wrote: How does your DBI driver represent a default column value in the results returned by the column_info() method? DBD::Pg quotes enough to allow it to work when passed back in verbatim, with parens to

Re: column_info()'s COLUMN_DEF values - literal vs function

2009-05-28 Thread Tim Bunce
On Wed, May 27, 2009 at 04:16:48PM +0100, Martin Evans wrote: Tim Bunce wrote: How does your DBI driver represent a default column value in the results returned by the column_info() method? Specifically, does it distinguish between default literal strings and default

Re: column_info()'s COLUMN_DEF values - literal vs function

2009-05-28 Thread Martin Evans
Tim Bunce wrote: On Wed, May 27, 2009 at 04:16:48PM +0100, Martin Evans wrote: Tim Bunce wrote: How does your DBI driver represent a default column value in the results returned by the column_info() method? Specifically, does it distinguish between default literal strings and default

Re: column_info()'s COLUMN_DEF values - literal vs function

2009-05-28 Thread Steffen Goeldner
Tim Bunce wrote: I'd be interested in the COLUMN_DEF values for other databases and DBDs but it's not urgent. Hopefully others can fill in the gaps. (Oracle and mysql are two big missing databases at the moment.). DBD::Oracle (s/current_user/user) undef, 'TST', 'MARTIN', 'A', '3', 'NUMBER',