Richard Broersma Jr wrote: > > --- Cultural Sublimation <cultural_sublimation@xxxxxxxxx> 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. Yeah, but it doesn't allow the NOT NULL specification. I don't think there's any way to do what the OP wants ATM. -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J Voy a acabar con todos los humanos / con los humanos yo acabaré voy a acabar con todos / con todos los humanos acabaré (Bender) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
