Re: [SQL] ar: Command not found.

2005-04-06 Thread Dinesh Pandey
Title: ar: Command not found. In Solaris "ar" command is in "/usr/ccs/bin" directory.   Thanks Dinesh Pandey   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dinesh PandeySent: Thursday, April 07, 2005 10:21 AMTo: 'PostgreSQL'Subject: [SQL] ar: Command not found. Hi I a

Re: [SQL] 9.17.5. Row-wise Comparison

2005-04-06 Thread Tom Lane
"TJ O'Donnell" <[EMAIL PROTECTED]> writes: > I've been using syntax like > select a from tbl where (b,c,d) > (1,2,3) >to mean > select a from t where b>1 and b>2 and d>3 > But I see in the manual at: > http://www.postgresql.org/docs/7.4/interactive/functions-comparisons.html#AEN12735 > that on

[SQL] ar: Command not found.

2005-04-06 Thread Dinesh Pandey
Title: ar: Command not found. Hi I am getting this error while "make install" of postgres. make[2]: ar: Command not found. make[2]: *** [libpgport.a] Error 127 make[2]: Leaving directory `/export/home/psingh/postgre/postgresql-8.0.1/src/port' make[1]: *** [install] Error 2 make[1]: L

[SQL] 9.17.5. Row-wise Comparison

2005-04-06 Thread TJ O'Donnell
In tbl with columns a,b,c,d. I've been using syntax like select a from tbl where (b,c,d) > (1,2,3) to mean select a from t where b>1 and b>2 and d>3 But I see in the manual at: http://www.postgresql.org/docs/7.4/interactive/functions-comparisons.html#AEN12735 that only = and <> operators are supp

Re: [SQL] [GENERAL] Problems with Set Returning Functions (SRFs)

2005-04-06 Thread Tom Lane
"Otto Blomqvist" <[EMAIL PROTECTED]> writes: > secom=# select f1, f2, f3 from testpassbyval(1, (Select number1 from test)); > ERROR: more than one row returned by a subquery used as an expression In 8.0 I think it'd work to do select (x).f1, (x).f2, (x).f3 from (select testpassbyval(1, number1)

Re: [SQL] DROP TYPE without error?

2005-04-06 Thread Mischa
Quoting Philippe Lang <[EMAIL PROTECTED]>: > Since it is not possible to use CREATE OR REPLACE TYPE, is there a way > of using DROP TYPE on a non-existing type, without causing the entire > script to abort? It may sound crazy to ask for this, but it could be > really useful in my case, where Pl/Pg

FW: [SQL] createlang 'pltclu' with postgreSQL.

2005-04-06 Thread Dinesh Pandey
Unable to run "createlang pltcl testdb" [1]. I tried with this command ./configure --with-tcl --with-tclconfig=/usr/local/lib . checking whether the C compiler still works... yes checking how to run the C preprocessor... gcc -E checking whether to build with Tcl... yes . . ch

Re: [SQL] createlang 'pltclu' with postgreSQL.

2005-04-06 Thread Dinesh Pandey
1. I installed with compiled package using "pkgadd -d postgresql-8.0.1-sol9-sparc-local" 2. I haven't used --with-tcl? Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr Sent: Wednesday, April 06, 2005 9:14 PM To: Dinesh P

Re: [SQL] createlang 'pltclu' with postgreSQL.

2005-04-06 Thread Dinesh Pandey
Hi Mike, Have you installed tcl and tk before popstgres installation and set some PATH for that before installing postgres.Because I installed  "tk-8.4.9-sol9-sparc-local.gz" and "tcl-8.4.9-sol9-sparc-local.gz" after postgres installation.Can I use "configure --with-tcl --with-tclconfig=/us

Re: [SQL] createlang 'pltclu' with postgreSQL.

2005-04-06 Thread Michael Fuhr
On Wed, Apr 06, 2005 at 07:39:02PM +0530, Dinesh Pandey wrote: > > I have already installed Postgres 8.0.1. How did you install PostgreSQL? Did you build it from source? > $ createlang pltclu testdb > ERROR: could not access file "$libdir/pltcl": No such file or directory > createlang: languag

[SQL] TIMESTAMP / summertime

2005-04-06 Thread T E Schmitz
Hello, I *detest* British summertime. This year it took me two days to adjust. Now I am realizing that my program might need some adjusting too: Joking aside, I need some advice regarding TIMESTAMP colums and I can't quite get my head round this at the moment: I created a table TRANSAKTION with a

[SQL] createlang 'pltclu' with postgreSQL.

2005-04-06 Thread Dinesh Pandey
Title: createlang 'pltclu' with postgreSQL. Hi, I have already installed Postgres 8.0.1. I am able to use pl/pgsql language but...I want to use language 'pltclu' with postgreSQL. Its unable to find "pltcl". I am getting this error. $ createlang pltclu testdb ERROR:  could not access f

[SQL] DROP TYPE without error?

2005-04-06 Thread Philippe Lang
Hi, Since it is not possible to use CREATE OR REPLACE TYPE, is there a way of using DROP TYPE on a non-existing type, without causing the entire script to abort? It may sound crazy to ask for this, but it could be really useful in my case, where Pl/Pgsql and Pl/Perl code is being generated automat

[SQL] CURSOR EXAMPLE - ORACLE TO POSTGRES CONVERSION

2005-04-06 Thread Dinesh Pandey
Title: CURSOR EXAMPLE - ORACLE TO POSTGRES CONVERSION CURSOR EXAMPLE - ORACLE TO POSTGRES CONVERSION --Oracle CREA

Re: [despammed] [SQL] Crosstab function

2005-04-06 Thread Andreas Kretschmer
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

Re: [SQL] Crosstab function

2005-04-06 Thread Richard Huxton
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,