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

From Martijn van Oosterhout
Subject Re: Cannot declare record members NOT NULL
Date
Msg-id 20070912220851.GB25528@svana.org
Whole thread Raw
In response to Re: Cannot declare record members NOT NULL  (Cultural Sublimation <cultural_sublimation@yahoo.com>)
Responses Re: Cannot declare record members NOT NULL
List pgsql-general
On Wed, Sep 12, 2007 at 02:22:46PM -0700, Cultural Sublimation wrote:
> SELECT movie_id, movie_name FROM get_movies ();
> => returns a SETOF of (int4 NULL, text NULL)

I presume you mean that the server is saying the column can be NULL,
not that it is actually NULL, since:

> One note: I know this information because the client is using the
> "describe" feature of Postgresql to retrieve the types returned
> by a statement.

The describe clearly can't tell if the result is always going to be
NULL or not.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Cannot declare record members NOT NULL
Next
From: Cultural Sublimation
Date:
Subject: Re: Cannot declare record members NOT NULL