If found this article of help: http://www.onjava.com/pub/a/onjava/2003/08/13/stored_procedures.html?page=2
On 6/30/05, Jason Tesser <[EMAIL PROTECTED]> wrote:
I am not familar with how to do this. Could you give me an example of howthis could help?>> Have you considered returing refcursors instead
You are amazing! It solved it! Thanks!!On 6/22/05, Stephan Szabo <[EMAIL PROTECTED]> wrote:
On Wed, 22 Jun 2005, Pablo Baena wrote:> FOR rec IN SELECT
test.id <http://test.id>, test.blow, test1.bla2> FROM test> LEFT JOIN test1 ON test.id <http://test.id> =
test1.id &l
This happens when using left join on the select.
This is a sample of what is happening to me.
-- The tables
CREATE TABLE test
(
id numeric,
blow varchar
) WITHOUT OIDS;
CREATE TABLE test1
(
id numeric,
bla2 varchar
) WITHOUT OIDS;
COPY test (id, blow) FROM stdin;1 sdasd2 sdaddxxsd4 s55
