PL/Perlu - list of columns

From: Sid <sid(dot)the(dot)technician(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PL/Perlu - list of columns
Date: 2010-07-18 11:17:16
Message-ID: AANLkTilmUAlZQWWxHVpFqia1C9PXIIieNjkt1ekQtYl_@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'am writing pl/perlu function, it executes some query using spi_exec_query.
What I want is to get list of fields even when query does not return any
rows.
Now I get this:
{
'status' => 'SPI_OK_SELECT',
'processed' => 0,
'rows' => []
}
Is there any way to get structure similar to dbi : $stmt->{'TYPE'}?

--
Best regards
Sid

Browse pgsql-general by date

  From Date Subject
Next Message Martin Gainty 2010-07-18 13:07:05 Re: NASA needs Postgres - Nagios help
Previous Message Howard Rogers 2010-07-17 23:28:32 Full Text Search ideas