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