DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=hOFkc6SbhtckFIsL65pilSm8ZfpHgZLd05faqLdROcvHicO5BrP8/9na6CFsqvRtrnwNoMGRmJBKXUQgyEDX0Kgs3uNUL5/D1E0oqYhL4yioo+PRKEEeH1xoJeAn2W7ZMOKpKdWIgxeHsfg9YwkHDeRS82M7AB8+nq68XzCVCPU=
	;
Message-ID: <20051120103145.96545.qmail@web52901.mail.yahoo.com>
Date: Sun, 20 Nov 2005 02:31:45 -0800 (PST)
From: CSN <cool_screen_name90001@yahoo.com>
Subject: Re: ruby/postgres - getting assoc array of rows?
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-interfaces@postgresql.org
In-Reply-To: <20051120053247.GA31157@winnie.fuhr.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit


I tried:
puts "by name:     #{row['id']} #{row['name']}"

but it exits with:
pg.rb:16:in `[]': can't convert String into Integer (TypeError)

The by position line does work though.

thanks
csn


--- Michael Fuhr <mike@fuhr.org> wrote:

> On Sat, Nov 19, 2005 at 08:14:40PM -0800, CSN wrote:
> > Looking at the docs here:
> > http://ruby.scripting.ca/postgres/reference.html
> > 
> > there doesn't appear to be an easy way to get an associative row
> > of rows returns.
> 
> What exactly are you looking for?  The example you posted returns
> an array of hashes, but depending on what you're doing all that
> work might not be necessary.  PGconn#exec returns a PGresult object,
> the PGresult#each iterator yields PGrow objects, and PGrow#[] accepts
> both numeric and text indexes.  Example:
> 
> % psql -d test -c 'SELECT id, name FROM people'
>  id | name  
> ----+-------
>   1 | Alice
> (1 row)
> 
> % cat test.rb
> require 'postgres'
> conn = PGconn.new('dbname=test')
> res = conn.exec('SELECT id, name FROM people')
> res.each do |row|
>   puts "by name:     #{row['id']} #{row['name']}"
>   puts "by position: #{row[0]} #{row[1]}"
> end
> res.clear
> conn.close
> 
> % ruby test.rb
> by name:     1 Alice
> by position: 1 Alice
> 
> You could also convert the PGresult object into an array of PGrow
> objects with a one-liner, although you wouldn't get automatic bytea
> handling as in the function you posted:
> 
> rows = res.collect
> 
> Will any of this work for you?  If not then please provide more
> detail.
> 
> -- 
> Michael Fuhr
> 


__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com