pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
plpqsql and RETURN NEXT requires a LOOP?
2+ messages / 2 participants
[nested] [flat]

* plpqsql and RETURN NEXT requires a LOOP?
@ 2006-03-21 17:51 Davidson, Robert <robdavid@amazon.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Davidson, Robert @ 2006-03-21 17:51 UTC (permalink / raw)
  To: pgsql-sql



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: plpqsql and RETURN NEXT requires a LOOP?
@ 2006-03-21 17:54 Owen Jacobson <ojacobson@osl.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Owen Jacobson @ 2006-03-21 17:54 UTC (permalink / raw)
  To: pgsql-sql

In general, to do anything useful with RETURN NEXT you need a loop.  However, it doesn't need to be a loop over another resultset: you can do a computation in a loop, returning values as you go.

Excuse the outlook-ism.

-Owen

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Davidson, Robert
Sent: Tuesday, March 21, 2006 9:51 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] plpqsql and RETURN NEXT requires a LOOP?




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-03-21 17:54 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-21 17:51 plpqsql and RETURN NEXT requires a LOOP? Davidson, Robert <robdavid@amazon.com>
2006-03-21 17:54 Re: plpqsql and RETURN NEXT requires a LOOP? Owen Jacobson <ojacobson@osl.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