subquery returnig more than one field - Mailing list pgsql-sql

From Jan Varga
Subject subquery returnig more than one field
Date
Msg-id Pine.LNX.4.10.10004071423570.3077-100000@frru.utcru.sk
Whole thread Raw
List pgsql-sql
Hi,

now I'm using query:

select id, c1(my_func(id)), c2(my_func(id)) from my_table

my_table ( id int
)

my_table2 ( c1 int, c2 int
)

my_function returns my_table2

but this quite inefficient because my_func is called twise for each row
Are there any possibilities to enhance this ?


Please reply to my e-mail too, because I'm not on the list
and mail archives are not functional at the moment


Thanks

Jan




pgsql-sql by date:

Previous
From: "Moray McConnachie"
Date:
Subject: Re: duplicates
Next
From: "Gerhard Dieringer"
Date:
Subject: Antw: duplicates