pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: 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