Skip site navigation (1) Skip section navigation (2)

Re: out parameter and setof record

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: out parameter and setof record
Date: 2006-05-31 05:04:09
Message-ID: 20060531050409.GA24008@webserv.wug-glas.de (view raw or flat)
Thread:
Lists: pgsql-general
am  30.05.2006, um  3:21:27 -0700 mailte uran1(at)o2(dot)pl folgendes:
> In PostgreSql 8.1 i've tried to use Out parameter but when I've changed
> function (added Out parameter)
> ...
> ----
> ERROR:  function result type must be integer because of OUT parameters
> ----
> 
> Of course when I change parameter to Integer it must be Record error
> appears.

A good explanation for IN/OUT-Parameters can you find there:
http://people.planetpostgresql.org/xzilla/index.php?/archives/149-out-parameter-sql-plpgsql-examples.html#extended


HTH Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    === 

In response to

pgsql-general by date

Next:From: liu longDate: 2006-05-31 05:30:45
Subject: How to link database A in server X to database B in server Y?
Previous:From: Alex TurnerDate: 2006-05-31 04:42:30
Subject: Re: SCSI disk: still the way to go?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group