Passing an array or record to a stored procedure in PostgreSQL

From: Max Bourinov <bourinov(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Passing an array or record to a stored procedure in PostgreSQL
Date: 2011-05-18 05:40:29
Message-ID: BANLkTinR16uuRY_uN8E0BxJ5DHNG5PpkBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Highly Respected Hackers!

I have a task to pass arrays, records and in some cases array of
records as a parameter to the stored procedures in PostgreSQL. I will
use JDBC to work with PostgreSQL 9.0 At first I would like to learn
how to pass arrays.

Any ideas?

p.s. Google and http://dba.stackexchange.com/ gave me no answer...

Thank you in advance!
Max

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Leonardo Francalanci 2011-05-18 07:34:35 Re: use less space in xl_xact_commit patch
Previous Message Jaime Casanova 2011-05-18 05:02:43 Re: LOCK DATABASE