Re: Cannot declare record members NOT NULL

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Cultural Sublimation <cultural_sublimation(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot declare record members NOT NULL
Date: 2007-09-12 22:18:05
Message-ID: 62727.79948.qm@web31801.mail.mud.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general


--- Cultural Sublimation <cultural_sublimation(at)yahoo(dot)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://stream.boxwatch.ru/docs/8.2/interactive/sql-select.html

notice this "from-type" listing for functions.

Regards,
Richard Broersma Jr.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-09-12 22:26:45 Re: Cannot declare record members NOT NULL
Previous Message Martijn van Oosterhout 2007-09-12 22:08:53 Re: Cannot declare record members NOT NULL