pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
TODO List
4+ messages / 3 participants
[nested] [flat]

* TODO List
@ 2001-07-20 15:21 Chris Ruprecht <chrup999@yahoo.com>
  2001-07-20 16:56 ` Re: TODO List Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Chris Ruprecht @ 2001-07-20 15:21 UTC (permalink / raw)
  To: pgsql-sql

Bruce,

while you're at TO-DO list additions:

I'd like to have a construct like:

loop
    if <condition> then
      next [loop];
    end if;
    [more statements]
end loop;

I want to be able to skip to the next iteration of the loop, if a certain
condition is met but I do not want to exit the loop all together. There
doesn't seem to be functionality for that right now.

Best regards,
Chris

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
[...]

>
> Both LIMIT and OFFSET seem to have that restriction.  I will add this to
> the TODO list.
>



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




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

* Re: TODO List
  2001-07-20 15:21 TODO List Chris Ruprecht <chrup999@yahoo.com>
@ 2001-07-20 16:56 ` Bruce Momjian <pgman@candle.pha.pa.us>
  2001-07-20 20:42   ` Re: TODO List Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Bruce Momjian @ 2001-07-20 16:56 UTC (permalink / raw)
  To: Chris Ruprecht <chrup999@yahoo.com>; +Cc: pgsql-sql

> Bruce,
> 
> while you're at TO-DO list additions:
> 
> I'd like to have a construct like:
> 
> loop
>     if <condition> then
>       next [loop];
>     end if;
>     [more statements]
> end loop;
> 
> I want to be able to skip to the next iteration of the loop, if a certain
> condition is met but I do not want to exit the loop all together. There
> doesn't seem to be functionality for that right now.

You want C 'continue' statement.  Is that for Pl/pgSQL?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



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

* Re: TODO List
  2001-07-20 15:21 TODO List Chris Ruprecht <chrup999@yahoo.com>
  2001-07-20 16:56 ` Re: TODO List Bruce Momjian <pgman@candle.pha.pa.us>
@ 2001-07-20 20:42   ` Josh Berkus <josh@agliodbs.com>
  2001-07-20 20:59     ` Re: TODO List Chris Ruprecht <chrup999@yahoo.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Josh Berkus @ 2001-07-20 20:42 UTC (permalink / raw)
  To: Bruce Momjian <pgman@candle.pha.pa.us>; Chris Ruprecht <chrup999@yahoo.com>; +Cc: pgsql-sql

Bruce, Chris,

A lot of us would like a fuller PL/SQL implementation in PL/pgSQL.
However, Jan is busy with other things and I don't see anyone stepping
up to the plate to take on the project.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco



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

* Re: TODO List
  2001-07-20 15:21 TODO List Chris Ruprecht <chrup999@yahoo.com>
  2001-07-20 16:56 ` Re: TODO List Bruce Momjian <pgman@candle.pha.pa.us>
  2001-07-20 20:42   ` Re: TODO List Josh Berkus <josh@agliodbs.com>
@ 2001-07-20 20:59     ` Chris Ruprecht <chrup999@yahoo.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Chris Ruprecht @ 2001-07-20 20:59 UTC (permalink / raw)
  To: pgsql-sql

Josh,

I would love to do something like that. Unfortunately, on a scale from 1 to
10, my C knowledge is about minus 5. Maybe, if my current project makes any
profit and I don't have to work for a boss any longer, I might find some
time to learn how to program in C and then, I might add the one or other
thing. I'd love to see pl/pgsql develop into what I saw the other day in the
Oracle PL/SQL book..

Best regards,
Chris


----- Original Message -----
From: "Josh Berkus" <josh@agliodbs.com>
To: "Bruce Momjian" <pgman@candle.pha.pa.us>; "Chris Ruprecht"
<chrup999@yahoo.com>
Cc: "p-sql" <pgsql-sql@postgresql.org>
Sent: Friday, July 20, 2001 3:42 PM
Subject: Re: [SQL] TODO List


> Bruce, Chris,
>
> A lot of us would like a fuller PL/SQL implementation in PL/pgSQL.
> However, Jan is busy with other things and I don't see anyone stepping
> up to the plate to take on the project.
>
> -Josh
>
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@agliodbs.com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




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


end of thread, other threads:[~2001-07-20 20:59 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-20 15:21 TODO List Chris Ruprecht <chrup999@yahoo.com>
2001-07-20 16:56 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-07-20 20:42   ` Josh Berkus <josh@agliodbs.com>
2001-07-20 20:59     ` Chris Ruprecht <chrup999@yahoo.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