[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>

reply via email to

[Prev in Thread] Current Thread [Next in Thread]