Jim C. Nasby wrote:
> On Sun, Aug 20, 2006 at 10:56:12PM -0700, Neil Conway wrote:
> > On Mon, 2006-08-21 at 07:31 +0200, Hans-Juergen Schoenig wrote:
> > > CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$
> > >SELECT relname::text, relpages::int4
> > >FROM pg_clas
On Sun, Aug 20, 2006 at 10:56:12PM -0700, Neil Conway wrote:
> On Mon, 2006-08-21 at 07:31 +0200, Hans-Juergen Schoenig wrote:
> > CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$
> >SELECT relname::text, relpages::int4
> >FROM pg_class;
> > $$ LANGUAGE SQL IMMUTAB
On Mon, 2006-08-21 at 07:31 +0200, Hans-Juergen Schoenig wrote:
> CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$
>SELECT relname::text, relpages::int4
>FROM pg_class;
> $$ LANGUAGE SQL IMMUTABLE;
> As far as i remember inlined SQL code has been implemented into
As my last mail did not seem to go through here one more try ...
When looking at some fairly complex SQL stuff I came across some
interesting issue which is a bit surprising to me:
CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$
SELECT relname::text, relpages::int4
