From: Greg Stark <gsstark@mit.edu>
To: John DeSoi <jd@icx.net>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: sleep function
Date: 22 Aug 2004 23:52:01 -0400
Message-ID: <87hdqu5x5q.fsf@stark.xeocode.com> (raw)
In-Reply-To: <46D44C5D-EBCF-11D8-A1CD-000A95B03262@icx.net>
References: <200408101457.i7AEvvc15187@candle.pha.pa.us>
<46D44C5D-EBCF-11D8-A1CD-000A95B03262@icx.net>
John DeSoi <jd@icx.net> writes:
> On Aug 10, 2004, at 10:57 AM, Bruce Momjian wrote:
>
> > I can't think of one, no. I think you will have to use one of the
> > server-side languages and call a sleep in there.
>
> This is no good in the real world since it pounds the CPU, but it worked well
> enough for my testing purposes.
You went the long way around. I think what he meant was something as simple
as:
bash-2.05b$ /usr/lib/postgresql/bin/createlang -U postgres plperlu test
bash-2.05b$ psql -d test -U postgres
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
test=# create or replace function sleep(integer) returns integer as 'return sleep(shift)' language plperlu;
CREATE FUNCTION
test=# \timing
Timing is on.
test=# select sleep(10) ;
sleep
-------
10
(1 row)
Time: 10002.493 ms
--
greg
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gsstark@mit.edu, jd@icx.net
Subject: Re: sleep function
In-Reply-To: <87hdqu5x5q.fsf@stark.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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