Re: [RDBO] ARRAY column types in Rose::DB

2005-12-01 Thread Torsten Seemann
John, > > What happens if someone manually shifted an element onto the front > > of a Pg 1-D array, and the string was changed to '[-1:4]{.}' > > does your parser handle that? > > No, I've never even seen that syntax. Will the database itself actually > return something like that? If so

Re: [RDBO] ARRAY column types in Rose::DB

2005-12-01 Thread John Siracusa
On 12/1/05 7:17 PM, Torsten Seemann wrote: > Does the generic code store them in a string of the same forma the Pg > uses to set them, ie. '{1,"foo",-3,"bar bie",1.61818}' ? Yes, although that's technically a private implementation detail :) > What happens if someone manually shifted an element o

[RDBO] ARRAY column types in Rose::DB

2005-12-01 Thread Torsten Seemann
John, I was surprised discover that Rose::DB supports ARRAY data types, natively in the Pg driver and via VARCHAR in other engines. I have some questions about this. Does the generic code store them in a string of the same forma the Pg uses to set them, ie. '{1,"foo",-3,"bar bie",1.61818}' ? Wha

Re: [RDBO] column_type_class

2005-12-01 Thread Torsten Seemann
On Wed, 2005-11-30 at 23:43 -0500, John Siracusa wrote: > On 11/30/05 11:29 PM, Torsten Seemann wrote: > > Just keep in mind that MySQL 'ENUM' stores them as integers, and that > > integer is ALWAYS reserved to store the empty string '' as 0. So even if > > you specify switch ENUM('off','on'), '' w