DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=rg9uTKPj5xHBv0kd2ZHULdt4W5uCxX2QA67wKgj7ssuHxFIsKoN7XcSYqhioTHtkJDWIIeK60SM1pVOQ83W1R4Zj8sTqPpjAdk0KQI0qNRbGWYFV7+q0CZaeKY0NVyLDmppAxNxu6ak85YzomyiQaxA0wm7y9eu2Vw99gXPXtlM=
	;
Message-ID: <20051120041440.29069.qmail@web52902.mail.yahoo.com>
Date: Sat, 19 Nov 2005 20:14:40 -0800 (PST)
From: CSN <cool_screen_name90001@yahoo.com>
Subject: ruby/postgres - getting assoc array of rows?
To: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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. Looking in Rails
PG code, I see this convolution:

        def select(sql, name = nil)
          res = execute(sql, name)
          results = res.result
          rows = []
          if results.length > 0
            fields = res.fields
            results.each do |row|
              hashed_row = {}
              row.each_index do |cel_index|
                column = row[cel_index]
                if res.type(cel_index) == BYTEA_COLUMN_TYPE_OID
                  column = unescape_bytea(column)
                end
                hashed_row[fields[cel_index]] = column
              end
              rows << hashed_row
            end
          end
          return rows
        end

Is there a much easier and simpler way?

csn


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