Обсуждение: Crosstab function
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....................
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
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 ===
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....................
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