--- Cultural Sublimation <[EMAIL PROTECTED]> wrote: > > I don't know if this will work, but here is another idea: > > > > SELECT movie_id, movie_name > > FROM get_movies() AS ( int4 NOT NULL, text NOT NULL ); > > > > Hi, > > Nope. That's not even valid syntax...
It isn't valid SQL spec syntax but it is a Postgresql-ism for functions return types: http://www.postgresql.org/docs/8.2/interactive/sql-select.html notice this "from-type" listing for functions. Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
