[Dbix-class] select * from function('param')

[Ash Berlin]

mock wrote:
> On Fri, Jul 28, 2006 at 12:20:54PM +0100, Ash Berlin wrote:
>   
>> mock wrote:
>>     
>>> Yeah, looks like I'm going to have to do the from hackery.
>>>
>>> So I tried the stupidly obvious:
>>>
>>> my $rs = $schema->resultset('Getcourses')->search(undef,
>>> {
>>>     from => 'getcourses(\'STUDENT\')',
>>> })->first;
>>>
>>> print "Name ",$rs->name, "\n";
>>>
>>> Which gives me this error:
>>>
>>> DBD::Pg::st execute failed: ERROR:  missing FROM-clause entry for table "me"
>>> DBIx::Class::ResultSet::first(): Error executing 'SELECT me.courseid, me.name, me.seattotal, me.seatleft, me.slot, me.priority, me.availid, me.begindate, me.enddate, me.couponname, me.coupontype, me.coupontotal, me.couponleft, me.price, me.tax, me.currency FROM getcourses('STUDENT')' (): ERROR:  missing FROM-clause entry for table "me"
>>>
>>> On first inspection it looks like it is doing what I want 
>>> "SELECT * FROM getcourses('STUDENT')"
>>> but I don't understand the error message.  The documentation talks a lot about
>>> custom joins, but that doesn't look like what I'm trying to do.  Any hints?
>>>
>>> mock
>>>   
>>>       
>> It is expecting:
>>
>>   SELECT ... FROM getcourses('STUDENT') me
>>
>> but the "me" (table alias) is missing.
>>
>> Try:
>>
>>   from => 'getcourses(\'STUDENT\') me',
>>
>> Not sure if there is a proper way of doing that or not tho
>>
>> -ash
>>
>>     
>
> my $rs = $schema->resultset('Getcourses')->search(undef,
> {
>   from => 'getcourses(\'STUDENT\') me',
> })->first;
> print "Name ",$rs->name, "\n";
>
>
> works!!!!
> I owe you a beer.  If you're going to YAPC::EU please collect from me.
>
> thanks
> mock
>   
Sadly I'm spending two weeks in the south of France when YPAC::EU is on 
- guess who booked train before checking the conference dates?

-a