personally they way I do it, is by creating temporary table, in
transaction - and use it in function. Obviously that's very indirect,
and not obvious if you see function's declaration. But works fine.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
On Mon, Jul 6, 2009 at 7:27 AM, sqlguru wrote:
> In SQL 2008, we could pass tables into stored procedures.
> CREATE TABLE members -- Only username is required
> (
> mem_username VARCHAR(25) NOT NULL PRIMARY KEY,
> mem_email VARCHAR(255),
> mem_fname VARCHAR(25),
> mem_lname VARCHAR(
sqlguru wrote:
In SQL 2008, we could pass tables into stored procedures.
CREATE TABLE members -- Only username is required
(
mem_username VARCHAR(25) NOT NULL PRIMARY KEY,
mem_email VARCHAR(255),
mem_fname VARCHAR(25),
mem_lname VARCHAR(25)
);
CREATE TABLE TYPE member_table_t
In SQL 2008, we could pass tables into stored procedures.
CREATE TABLE members -- Only username is required
(
mem_username VARCHAR(25) NOT NULL PRIMARY KEY,
mem_email VARCHAR(255),
mem_fname VARCHAR(25),
mem_lname VARCHAR(25)
);
CREATE TABLE TYPE member_table_type
(
mem_