pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: BSC
4+ messages / 4 participants
[nested] [flat]
* Re: BSC
@ 2000-02-16 14:06 Vladimir Terziev <vlady@school.digsys.bg>
2000-02-16 15:58 ` Re: [SQL] Re: BSC Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
2000-02-16 16:17 ` Re: [SQL] Re: BSC Peter Eisentraut <e99re41@DoCS.UU.SE>
0 siblings, 2 replies; 4+ messages in thread
From: Vladimir Terziev @ 2000-02-16 14:06 UTC (permalink / raw)
To: pgsql-sql
Hi,
I have a function written in plpgsql.
I want that function to return a list of values (as SQL returns rows of a
table).
How can I do this?
Vladimir
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] Re: BSC
2000-02-16 14:06 Re: BSC Vladimir Terziev <vlady@school.digsys.bg>
@ 2000-02-16 15:58 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
1 sibling, 0 replies; 4+ messages in thread
From: Kovacs Zoltan Sandor @ 2000-02-16 15:58 UTC (permalink / raw)
To: Vladimir Terziev <vlady@school.digsys.bg>; +Cc: pgsql-sql
> I want that function to return a list of values (as SQL returns rows of a
> table).
>
> How can I do this?
I am afraid you cannot. Only one row can be returned with the type OPAQUE.
Usually I write a "SELECT functionname(arguments);" query to solve this
problem. The other solution can be that you create a table (outside
your plpgsql function), then fill it out with INSERT statements inside
the plpgsql function. I did not manage to create a table inside the
function and I could not do a few important other things (e.g. CREATE
USER, sub-SELECT), but with a little help of additional sql language
functions was enough for my problem.
You can find a quite complicated implementation of partially ordered sets
on
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz/Linux/PostgreSQL/strukturak/
Here you can find po.sql, this is a basic English translation of the
Hungarian reszbenrendezes.sql file. The table "po" stores only the Hasse
diagram of the partially ordered set.
If you find it worthful, I am glad to contribute it. I hope it does not
work too slow. (Table "po" should be indexed.)
Zoltan
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] Re: BSC
2000-02-16 14:06 Re: BSC Vladimir Terziev <vlady@school.digsys.bg>
@ 2000-02-16 16:17 ` Peter Eisentraut <e99re41@DoCS.UU.SE>
1 sibling, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2000-02-16 16:17 UTC (permalink / raw)
To: Vladimir Terziev <vlady@school.digsys.bg>; +Cc: pgsql-sql
On Wed, 16 Feb 2000, Vladimir Terziev wrote:
> I have a function written in plpgsql.
>
> I want that function to return a list of values (as SQL returns rows of a
> table).
>
> How can I do this?
You can't.
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] Re: BSC
@ 2000-02-17 00:17 omid omoomi <oomoomi@hotmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: omid omoomi @ 2000-02-17 00:17 UTC (permalink / raw)
To: vlady@school.digsys.bg; pgsql-sql
Hi,
Why not using an array as the returned variables?
Omid Omoomi
>From: Vladimir Terziev <vlady@school.digsys.bg>
>To: pgsql-sql@postgreSQL.org
>Subject: [SQL] Re: BSC
>Date: Wed, 16 Feb 2000 16:06:12 +0200 (EET)
>
> Hi,
>
> I have a function written in plpgsql.
>
> I want that function to return a list of values (as SQL returns rows of
>a
>table).
>
> How can I do this?
>
> Vladimir
>
>************
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-02-17 00:17 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-16 14:06 Re: BSC Vladimir Terziev <vlady@school.digsys.bg>
2000-02-16 15:58 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
2000-02-16 16:17 ` Peter Eisentraut <e99re41@DoCS.UU.SE>
2000-02-17 00:17 Re: [SQL] Re: BSC omid omoomi <oomoomi@hotmail.com>
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