Postgres Pro
Downloads
Home   >   mailing lists

Thread: Crosstab function

Crosstab function

From
bandeng
Date:
hello guys,

I want to use crosstab function but that function it doesnt exist. my
version is 7.3 so how do i get the tablefunc.sql from postgre contrib?
i saw in ver 8 win32 is checkable.

Thanks
Ricky

-- 
Gutten Aben Sugeng Sonten, Jangane Kurang Santen
bandeng....................

Re: Crosstab function

From
Richard Huxton
Date:
bandeng wrote:
> hello guys,
> 
> I want to use crosstab function but that function it doesnt exist. my
> version is 7.3 so how do i get the tablefunc.sql from postgre contrib?
> i saw in ver 8 win32 is checkable.

Is it not in the contrib/ directory? Or did you install from a package 
of some sort (and if so, what sort).

--   Richard Huxton  Archonet Ltd

Re: [despammed] Crosstab function

From
Andreas Kretschmer
Date:
am  06.04.2005, um 13:55:35 +0700 mailte bandeng folgendes:
> hello guys,
> 
> I want to use crosstab function but that function it doesnt exist. my
> version is 7.3 so how do i get the tablefunc.sql from postgre contrib?

apt-get install postgresql-contrib


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===

Re: [despammed] Crosstab function

From
bandeng
Date:
I have install postgresql-contrib finally... i'm newbie in server.
I use freebsd 4.8, I saw in documentation it is said use tablefunc.sql
but in freebsd i found file tablefunc.so , it is already compiled. is
there suggestion to install tablefunc.so ?

Thank you
Ricky

On Apr 6, 2005 3:32 PM, Andreas Kretschmer <akretschmer@despammed.com> wrote:
> am  06.04.2005, um 13:55:35 +0700 mailte bandeng folgendes:
> > hello guys,
> >
> > I want to use crosstab function but that function it doesnt exist. my
> > version is 7.3 so how do i get the tablefunc.sql from postgre contrib?
> 
> apt-get install postgresql-contrib
> 
> Regards, Andreas
> --
> Andreas Kretschmer    (Kontakt: siehe Header)
> Heynitz:  035242/47212,      D1: 0160/7141639
> GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
> ===    Schollglas Unternehmensgruppe    ===
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> 


-- 
Gutten Aben Sugeng Sonten, Jangane Kurang Santen
bandeng....................

Re: [despammed] Crosstab function

From
Markus Schaber
Date:
Hi, Bandeng,

bandeng schrieb:
> I have install postgresql-contrib finally... i'm newbie in server.
> I use freebsd 4.8, I saw in documentation it is said use tablefunc.sql
> but in freebsd i found file tablefunc.so , it is already compiled. is
> there suggestion to install tablefunc.so ?

I think you misunderstood the relationship between tablefunc.so and
tablefunc.sql, as the former one is not the compiled form of the latter one.

The .sql file contains the statements that create functions, datatypes,
aggregates etc. For functions programmed in C,  SQL function definitions
eference the .so file and the function symbol name therein so postgresql
can load the library and jump into the C code functions, but the SQL
files could also define functions by including their source (for
languages such as plpgsql).

So to "install" the .so file, you have use psql -f tablefunc.sql yourdb.

Markus