pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: David Witham <davidw@unidial.com.au>
To: Mario Alberto Soto Cordones <mario_soto@compuall.cl>
To: pgsql-sql@postgresql.org
Subject: Re: FUNCTIONS PROBLEM
Date: Mon, 24 Mar 2003 10:18:27 +1100
Message-ID: <CFA248776934FD43847E740E43C346D1379688@ozimelb03.ozicom.com> (raw)

Hi Mario,

I have used a record type to do this:

create myfunc() returns record as '

declare
	return_val	record;
	col1		int;
	col2		int;
	col3		real;
	col4		char;

	col1 := 5;
	col2 := 10;
	col3 := 2.7;
	col4 := ''z'';

	select col1,col2,col3,col4 into return_val;
	return return_val;
end;
' language 'plpgsql';

When you call the function you need to specify the expected output:

select * from myfunc() as (val1 int, val2 int, val3 real, val4 char);

See the SELECT reference page in the documentation.

There are other ways (which may be better) to do this that don't require the output types to be specified with the query but this is the one I got going first so I stuck with it. Hope this helps.

Regards,
David Witham
Telephony Platforms Architect
Unidial

-----Original Message-----
From: Mario Alberto Soto Cordones [mailto:mario_soto@compuall.cl]
Sent: Friday, 21 March 2003 09:26
To: pgsql-sql@postgresql.org
Subject: [SQL] FUNCTIONS PROBLEM
Importance: High


Hi.

i have a function and i need to return 4 fields but not work,

any idea , please

thank

mario



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster




view thread (3+ messages)  latest in thread

Message-ID: <CFA248776934FD43847E740E43C346D1379688@ozimelb03.ozicom.com>
Permalink:  ../CFA248776934FD43847E740E43C346D1379688@ozimelb03.ozicom.com/
Also on:    postgresql.org/message-id/CFA248776934FD43847E740E43C346D1379688@ozimelb03.ozicom.com

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: davidw@unidial.com.au, mario_soto@compuall.cl
  Subject: Re: FUNCTIONS PROBLEM
  In-Reply-To: <CFA248776934FD43847E740E43C346D1379688@ozimelb03.ozicom.com>
  References: <CFA248776934FD43847E740E43C346D1379688@ozimelb03.ozicom.com>

* 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