is more about: "where do I need to place the tablefunc
> files (and which ones) in order to execute successfully that command"?
make install should copy files including $libdir/tablefunc. If not,
you should take a look at the output of the make command. Make sure
your PATH points to
calar product.)
>
>> That's a 30x speedup, from 12 minutes down to 38s. Thanks Tom!
>
> Huh, I would've bet on a lot more actually. The nodeFunctionscan and
> nodeAgg code must not be as inefficient as it looks on the surface ...
Did you mean in that case you can o
sser
What exactly is "OLAP functionality" you mention? You can use window
function from 8.4 on:
SELECT row_number() OVER () FROM tbl;
Regards,
--
Hitoshi Harada
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://ww
queries like the following:
>
>
>
> SELECT * FROM sometable WHERE (XPATH('/a:bar', somexmlcolumn,
> ARRAY[ARRAY['a', 'http://foo']]))<>('{}'::XML[])
>
>
>
> Any ideas and feedback are welcome.
>
>
>
> C
INSERT INTO table
SELECT nextval('seq'), col1, col2...
FROM table
WHERE pkey = curval('seq');
Regards,
Hitoshi Harada
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of SunWuKung
> Sent: Thursday, November 16, 2006 5:4
statistic from SQL or pgsql function should
be prepared on future version??
Regards,
Hitoshi Harada
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Glen Parker
> Sent: Friday, November 10, 2006 11:05 AM
> To: Postgres General
>
this:
---
timestamp2tm(timestamp, NULL, tm, &fsec, NULL
#if PG_VERSION > 8.1
,NULL
#endif
)
---
but couldn't, PG_VERSION is string type.
any other macro or definitions??
Regards,
Hitoshi Harada
---(end of broadcast)---
TIP 9: In version
