Re: Cannot declare record members NOT NULL

["Rodrigo De León" <rdeleonp@xxxxxxxxx>]

On 9/12/07, Cultural Sublimation <cultural_sublimation@xxxxxxxxx> wrote:
> Thanks for the help!

Not really following you, but try these:

CREATE OR REPLACE FUNCTION GET_MOVIES ()
RETURNS SETOF MOVIES
LANGUAGE SQL STABLE
AS
$$
SELECT MOVIE_ID, MOVIE_NAME FROM MOVIES;
$$;

-- OR --

CREATE OR REPLACE FUNCTION GET_MOVIES (OUT MOVIE_ID INT4, OUT MOVIE_NAME TEXT)
RETURNS SETOF RECORD
LANGUAGE SQL STABLE
AS
$$
SELECT MOVIE_ID, MOVIE_NAME FROM MOVIES;
$$;

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster