[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Chicken-users] Re: postgresql egg question
|
From: |
Johannes Grødem |
|
Subject: |
Re: [Chicken-users] Re: postgresql egg question |
|
Date: |
Tue, 11 Jan 2005 13:41:17 +0100 |
|
User-agent: |
Gnus/5.1007 (Gnus v5.10.7) Emacs/21.3 (gnu/linux) |
* Larry White <address@hidden>:
> --(define conn (pg:connect '((dbname . "torii"))))
> --(pg:query-tuples "select * from list_users()" conn)
#;4> (pg:query-tuples "SELECT * FROM list_users()" con)
(#("<unnamed portal 1>"))
#;5> (pg:query-tuples "FETCH ALL IN \"<unnamed portal 1>\"" con)
Should work. That is, the function returns a string naming the
cursor, which you can then use as an identifier to do e.g. FETCH. (I
think you have to do this within a transaction.)
--
Johannes Grødem <OpenPGP: 5055654C>