pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Adrian Klaver <aklaver@comcast.net>
To: pgsql-sql@postgresql.org
Cc: peterw@borstad.com
Subject: Re: FUNCTION problem
Date: Fri, 3 Apr 2009 06:51:05 -0700
Message-ID: <200904030651.05480.aklaver@comcast.net> (raw)
In-Reply-To: <200904021816.44804.aklaver@comcast.net>
References: <1521645855.2691471238710811603.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net>
	<49D5489E.5010904@borstad.com>
	<200904021816.44804.aklaver@comcast.net>

On Thursday 02 April 2009 6:16:44 pm Adrian Klaver wrote:
>
>
> Now I remember. Its something that trips me up, the RECORD in RETURN setof
> RECORD is not the same thing as the RECORD in DECLARE RECORD. See below for
> a better explanation-
> http://www.postgresql.org/docs/8.3/interactive/plpgsql-declarations.html#PL
>PGSQL-DECLARATION-RECORDS Note that RECORD is not a true data type, only a
> placeholder. One should also realize that when a PL/pgSQL function is
> declared to return type record, this is not quite the same concept as a
> record variable, even though such a function might use a record variable to
> hold its result. In both cases the actual row structure is unknown when the
> function is written, but for a function returning record the actual
> structure is determined when the calling query is parsed, whereas a record
> variable can change its row structure on-the-fly.
>
>
>
> --
> Adrian Klaver
> aklaver@comcast.net


For this particular case the following works. 

CREATE OR REPLACE FUNCTION test_function(integer) RETURNS record
    AS $Body$
DECLARE croid integer;
DECLARE R RECORD;
BEGIN
	SELECT INTO croid 2;
	SELECT INTO R  croid,$1;
RETURN R;
END;

$Body$
    LANGUAGE plpgsql;

-- 
Adrian Klaver
aklaver@comcast.net



view thread (13+ messages)  latest in thread

Message-ID: <200904030651.05480.aklaver@comcast.net>
Permalink:  ../200904030651.05480.aklaver@comcast.net/
Also on:    postgresql.org/message-id/200904030651.05480.aklaver@comcast.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: aklaver@comcast.net, peterw@borstad.com
  Subject: Re: FUNCTION problem
  In-Reply-To: <200904030651.05480.aklaver@comcast.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox