[Dbix-class] 2-argument SQL agregates

[Matt S Trout]

Doran L. Barton wrote:
> Doran L. Barton wrote:
>> Matt S Trout wrote:
>>> Doran L. Barton wrote:
>>>> I specifically need to use the TO_CHAR() function which takes a field
>>>> name and a format string:
>>>>
>>>> 	SELECT foo, TO_CHAR('bar', 'Month DD YYYYY') FROM Artist
>>> { TO_CHAR => [ 'bar', 'Month DD YYYY' ] } ?
>>>
>>> Always try the obvious thing first (this assumes you have quoting turned on. 
>>> if you don't, you probably want \"'Month DD YYYY'")
> 
>> Here is the error showing up in the logs now when I try using the above code 
>> to include a TO_CHAR(arg1, arg2) in the code:
>>
>> 	Cannot mix placeholder styles ":foo" and "?" at 
>> /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/DBD/Pg.pm line 188.
> 
> Well, I tried quoting the format string like you suggested and... what do 
> you know?! IT WORKED!
> 
> Quoting? Turn on? Could you point me in the general direction?

Storage::DBI - $storage->sql_maker->quote_char

-- 
      Matt S Trout       Offering custom development, consultancy and support
   Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +