in message
news:[EMAIL PROTECTED]
> On Tue, Oct 19, 2004 at 01:44:34PM -0500, Hicham G. Elmongui wrote:
> > I need this for a side project. Is there a way to do something like
this:
> >
> > SELECT *
> > FROM DelayedTable('tablename', 5);
>
> You can p
what does this message mean?
thanks,
--h
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
i do no think writing the query in the second form differs from the first
one. In both cases, only the relevent articles (in range and of desired
type) will come out of the scan operator that scans the articles.
--h
"Dennis Gearon" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> My
is there a way to create a table with a certain type?
CREATE TYPE typename AS (id integer, name varchar);
and something like
CREATE TABLE names OF TYPE typename.
Is there a syntax to support this?
thanks,
--h
---(end of broadcast)---
TIP 4: D
I need this for a side project. Is there a way to do something like this:
SELECT *
FROM DelayedTable('tablename', 5);
DelayedTable provides me with one tuple every 5 seconds.
Regards,
--h
"Hicham G. Elmongui" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECT
I need to select all tuples from a table, but need them to be fetched with a
constant delay (say 1 sec) between every consecutive tuples.
The first idea that came up to my mind is to create a DelayedSeqScan
operator, and put delay before returning the scanned tuple.
Can I do this functionality us
Hi
I tried creating the function (from sec 19.3.1). But it gives me the
following error: "ERROR: type tablename does not exist".
Any ideas of what i might be doing wrong?
CREATE FUNCTION use_many_fields(tablename) RETURNS TEXT AS '
DECLARE
in_t ALIAS FOR $1;
BEGIN
RETURN in_t.f1 || in_t.f
