From: | Brian Hurt <bhurt(at)janestcapital(dot)com> |
---|---|
To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How do I insert a record into a table? |
Date: | 2007-06-01 19:55:47 |
Message-ID: | 466079C3.9020106@janestcapital.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Richard Broersma Jr wrote:
>--- Brian Hurt <bhurt(at)janestcapital(dot)com> wrote:
>
>
>
>>I want to write a query like:
>>INSERT INTO table SELECT func(args);
>>where func is defined as:
>>CREATE OR REPLACE FUNCTION func(args)
>>RETURNS table
>>AS $_$
>> ...
>>$_$ LANGUAGE plpgsql;
>>Unfortunately, when I try to do this, I get:
>>ERROR: column "first_column" is of type integer but expression is of
>>type record
>>I get this error even if I list the columns:
>>INSTER INTO table(first_column, second_column, ...) ....
>>So how do I take a record returned from a function, and insert it as a
>>row into a table?
>>
>>
>
>What does a select * from table; look like?
>What does a select * from func(args); look like?
>
>
>
The same. Note that I defined func to return type table.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2007-06-01 20:00:53 | Re: How do I insert a record into a table? |
Previous Message | Brian Hurt | 2007-06-01 19:54:43 | Re: How do I insert a record into a table? |