Re: [GENERAL] Cannot declare record members NOT NULL

[Rodrigo De León]

On 9/12/07, Cultural Sublimation <[EMAIL PROTECTED]> 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