Re: Cannot declare record members NOT NULL - Mailing list pgsql-general

--- Cultural Sublimation <cultural_sublimation@yahoo.com> 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.