Re: [GENERAL] Creating an index on PostgreSQL 7.4.3

2006-04-05 Thread Ardian Xharra \(Boxxo\)
Sorry, the exact version is PostgreSQL 7.3.3 on sparc-sun-solaris2.8, compiled by GCC gcc (GCC) 3.3.2 - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Ardian Xharra (Boxxo)" <[EMAIL PROTECTED]> Cc: ; "Martijn van Oosterhout" Sent:

Re: [GENERAL] Creating an index on PostgreSQL 7.4.3

2006-04-05 Thread Ardian Xharra \(Boxxo\)
No, it doesn't work always the same message: ERROR: parser: parse error at or near "(" at character 47 - Original Message - From: "Martijn van Oosterhout" To: "Ardian Xharra (Boxxo)" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, April 05, 2006 3

[GENERAL] Creating an index on PostgreSQL 7.4.3

2006-04-05 Thread Ardian Xharra (Boxxo)
Hello, I have a client who is still using the version 7.4.3 and creating an index like this doesn't work: CREATE INDEX client__ascname__idx  ON client (TO_ASCII(lower(name),'LATIN 1')); Does exists another way of creating an index in varchar who take on consideration also the accents

[GENERAL] Creating serial ID on Windows.

2006-03-27 Thread Ardian Xharra (Boxxo)
I'm having some troubles restoring a database on Windows and I found this difference between PostgreSQL running on Linux and Windows. When I create a table like this: CREATE TABLE fee_payment1(id_fee_payment1 serial NOT NULL) WITH OIDS; On Linux platform it will be: CREATE TABLE fee_p

Re: [GENERAL] Query in postgreSQL version Windows

2006-01-03 Thread Ardian Xharra \(Boxxo\)
Thank you Micheal it was the add_missing_from And sorry for the last post I didn't read the whole message from you. Ardian -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.11/219 - Release Date: 02/01/2006

Re: [GENERAL] Query in postgreSQL version Windows

2006-01-03 Thread Ardian Xharra \(Boxxo\)
I was doing the queries in SQL - Original Message - From: "Michael Fuhr" <[EMAIL PROTECTED]> To: "Ardian Xharra (Boxxo)" <[EMAIL PROTECTED]> Cc: Sent: Monday, January 02, 2006 4:29 PM Subject: Re: [GENERAL] Query in postgreSQL version Windows > On Mon, Jan

[GENERAL] Query in postgreSQL version Windows

2006-01-02 Thread Ardian Xharra \(Boxxo\)
Hello, there I installed PostgreSQL on windows and when I try to run some queries pgadmin says an error. I know that if I change the query this it will work but is it possible to make this quey work in this way   SELECT atthasdef FROM pg_attribute WHERE attrelid=pg_class.oid AND pg

[GENERAL] Query in postgreSQL version Windows

2006-01-02 Thread Ardian Xharra \(Boxxo\)
Hello, there I installed PostgreSQL on windows and when I try to run some queries pgadmin says an error. I know that if I change the query this it will work but is it possible to make this quey work in this way   SELECT atthasdef FROM pg_attribute WHERE attrelid=pg_class.oid AND pg