John Siracusa wrote:
> On 7/8/06 11:22 AM, Ash Berlin wrote:
>
>> John Siracusa wrote:
>>
>>> Another alternative is:
>>>
>>> INSERT INTO foo (anycol) VALUES (DEFAULT);
>>>
>>> That works in MySQL and Postgres, where anycol is literally any column in
>>> the table.
>>>
>>> That said, so far, I haven't found a syntax that works "everywhere." This
>>> type of thing has to be constructed on a case-by-case basis for each db.
>>>
>> To do that in DBIx:
>>
>> $rs->create({ anycol => \'DEFAULT' });
>>
>> But still not portable
>>
>
> When I said "constructed on a case-by-case basis," I meant by the library,
> not the user. So you'd do this:
>
> $rs->create({});
>
> and it'd Do The Right Thing for whatever db $rs is connected to.
>
> (or $rs->create(), if that's not too scary for some people :)
> -John
>
>
Agreed - simply noting it in case George wants to get on with it :)
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
