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

> Why do you create an extra type for that?
> Just have your method return "movies"

Hi,

Thanks for the answer.  The simple example obfuscates the fact that in reality
the table has a few extra columns that are omitted from get_movies_t.
Therefore, I cannot return "movies".

However, your answer did give me an idea:  instead of declaring "get_movies_t"
as a record, I declare it as dummy table, and return that (see code at the
end).
This works, though it is *very* ugly.  Any other ideas?

Thanks,
C.S.


CREATE TABLE get_movies_t
(
movie_id                int4 NOT NULL,
movie_name              text NOT NULL
);

CREATE FUNCTION get_movies ()
RETURNS SETOF get_movies_t
LANGUAGE sql STABLE
AS
$$
SELECT movie_id, movie_name FROM movies;
$$;





      ____________________________________________________________________________________
Shape Yahoo! in your own image.  Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7