Thread: select * from function()
I swear someone posted a message indicating that we would be getting the abillity to select * From function(): as opposed to the current select function(cursorname); fetch all in "cursorname"; Was I hallucinating? Thanks! Ian
"Ian Harding" <ianh@tpchd.org> writes: > I swear someone posted a message indicating that we would be getting the abillity to > > select * From function(): > > as opposed to the current > > select function(cursorname); > fetch all in "cursorname"; > > Was I hallucinating? No. This feature is in 7.3beta--is that what you're running? -Doug
On Tue, 12 Nov 2002, Ian Harding wrote: > I swear someone posted a message indicating that we would be getting the abillity to > > select * From function(): > > as opposed to the current > > select function(cursorname); > fetch all in "cursorname"; > > Was I hallucinating? No. 7.3 is able to use set returning functions like that.
I'm still in 7.2.* but I was looking at the beta docs and didn't see it there. I must be looking in the wrong place. http://developer.postgresql.org/docs/postgres/plpgsql-cursors.html >>> Doug McNaught <doug@mcnaught.org> 11/12/02 10:53AM >>> "Ian Harding" <ianh@tpchd.org> writes: > I swear someone posted a message indicating that we would be getting the abillity to > > select * From function(): > > as opposed to the current > > select function(cursorname); > fetch all in "cursorname"; > > Was I hallucinating? No. This feature is in 7.3beta--is that what you're running? -Doug ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
Ian Harding wrote: > I'm still in 7.2.* but I was looking at the beta docs and didn't see it > there. I must be looking in the wrong place. > > http://developer.postgresql.org/docs/postgres/plpgsql-cursors.html > See: general -> http://developer.postgresql.org/docs/postgres/xfunc-tablefunctions.html sql -> http://developer.postgresql.org/docs/postgres/xfunc-sql.html (sec 9.2.4) C -> http://developer.postgresql.org/docs/postgres/xfunc-c.html (sec 9.5.6) plpgsql -> http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html usage -> http://developer.postgresql.org/docs/postgres/sql-select.html (from_item, inputs, from clause, usage) Possibly others, but that's all I can think of. HTH, Joe
Yikes! I was skimming when I should have sat down and read. Thanks! >>> Joe Conway <mail@joeconway.com> 11/12/02 11:15AM >>> Ian Harding wrote: > I'm still in 7.2.* but I was looking at the beta docs and didn't see it > there. I must be looking in the wrong place. > > http://developer.postgresql.org/docs/postgres/plpgsql-cursors.html > See: general -> http://developer.postgresql.org/docs/postgres/xfunc-tablefunctions.html sql -> http://developer.postgresql.org/docs/postgres/xfunc-sql.html (sec 9.2.4) C -> http://developer.postgresql.org/docs/postgres/xfunc-c.html (sec 9.5.6) plpgsql -> http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html usage -> http://developer.postgresql.org/docs/postgres/sql-select.html (from_item, inputs, from clause, usage) Possibly others, but that's all I can think of. HTH, Joe