Function

Summary

Returns the results of mapping a function across an SQL query statement.

Package

sql

Signature

map-query output-type-spec function query-exp &key database => result

Arguments

output-type-spec

The output type specification.

result-type

The result sequence type.

function

A function.

query-exp

An SQL query.

database

A database.

Values

result

A sequence of type output-type-spec containing the results of the map function.

Description

The function map-query returns the result of mapping function across the results of query-expression . The output-type-spec argument specifies the type of the result sequence as per the Common Lisp map function.

The default value of database is *default-database* .

Example

This example binds name to each name in the employee table and prints it.

(map-query

   nil

   #
'(lambda (name) (print name))

   [select [ename] :from [emp] :flatp t])

See also

do-query
loop
print-query
query
select