| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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 ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | liu long | 2006-05-31 05:30:45 | How to link database A in server X to database B in server Y? |
| Previous Message | Alex Turner | 2006-05-31 04:42:30 | Re: SCSI disk: still the way to go? |