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

[Mihai Bazon]

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