[Cl-perec-devel] How to select individual fields?

[Borbély Tamás]

Hi,

It was really suboptimal. This patch hopefully fix it:

Mon Oct 19 15:33:08 CEST 2009  tomi.borbely at gmail.com
  * optimization of queries that select slot values only

regards,
Tomi

2009/10/16 Mihai Bazon <mihai at bazon.net>

> Hi,
>
> I'm trying to write a query that selects only a few fields.
>
> Example that works:
>
>  (select ((create-time-of o))
>    (from (o db-template)))
>
>  ; SELECT _o._create_time FROM _db_template_ap _o
>
> Adding one more field though results in a SELECT that covers all
> fields:
>
>  (select ((create-time-of o) (modify-time-of o))
>    (from (o db-template)))
>
>  ; SELECT _o._oid, _o._edition, _o._create_time, _o._modify_time,
>  _o._name, _o._body_type, _o._edited_body, _o._processed_body,
>  _o._parent_oid FROM _db_template_ap _o
>
> Is there any way to fetch more than one field, but not all, in a single
> query?
>
> Thanks,
> -Mihai
> _______________________________________________
> Cl-perec-devel mailing list
> Cl-perec-devel at common-lisp.net
> http://common-lisp.net/cgi-bin/mailman/listinfo/cl-perec-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.common-lisp.net/pipermail/cl-perec-devel/attachments/20091019/3dbeb357/attachment.html>