[GENERAL] ADD_Months Function in Postgres

2003-09-02 Thread Amin Schoeib
Title: ADD_Months Function in Postgres Hi, I would like to know if there is a Function in Postgres Like the add_months Function in Oracle?? Thanxx Schoeib 4Tek Gesellschaft für angewandte Informationstechnologien mbH Schoeib Amin Tel.  +49 (0) 69 697688-132 Fax. +49 (0) 69 697688-

[GENERAL] Problems with GRANTING SELECT to a table

2003-09-02 Thread Amin Schoeib
Title: Problems with GRANTING SELECT to a table Hi, I have a problem with permissions for SELECT. Here is what I did: test=> GRANT SELECT ON "poi"."fondsstamm" TO "flex"; GRANT test=> \dp fondsstamm;     Access privileges for database "test"  Schema |   Table    |   Access

[GENERAL] LAST_DAY Function in Postgres

2003-09-02 Thread Amin Schoeib
Title: LAST_DAY Function in Postgres Hi, I would like to know if there is a Function in Postgres Like the LAST_DAY Function in Oracle?? In Oracle you can use the function the get the last day of a month. Thanxx Schoeib 4Tek Gesellschaft für angewandte Informationstechnologien mbH S

Re: [GENERAL] Trunc in Postgres

2003-09-03 Thread Amin Schoeib
: Amin Schoeib Cc: [EMAIL PROTECTED] Betreff: Re: [GENERAL] Trunc in Postgres You can try select CAST(cast('4' as NUMERIC(20)) AS varchar); Pavel > > Hi, > Is there an equivalent for the trunc function of Oracle in Postgres??? > I need to trunc(the ze

Re: [GENERAL] Localization (for dates) Oracle vs. Postgresql

2003-09-03 Thread Amin Schoeib
I perform with to_char That I become the monthname in german?? -Ursprüngliche Nachricht- Von: Tom Lane [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 3. September 2003 16:21 An: Amin Schoeib Cc: [EMAIL PROTECTED] Betreff: Re: AW: [GENERAL] Localization (for dates) Oracle vs. Postgresq

Re: [GENERAL] Localization (for dates) Oracle vs. Postgresql

2003-09-03 Thread Amin Schoeib
Is there maybe any other??? -Ursprüngliche Nachricht- Von: Karel Zak [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 3. September 2003 16:53 An: Tom Lane Cc: Amin Schoeib; [EMAIL PROTECTED] Betreff: Re: AW: AW: [GENERAL] Localization (for dates) Oracle vs. Postgresql On Wed, Sep 03

Re: [GENERAL] German special characters Problem

2003-09-09 Thread Amin Schoeib
So what can I do that I don't get wrong characters??? -Ursprüngliche Nachricht- Von: Dennis Gearon [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 9. September 2003 16:11 An: Amin Schoeib Cc: [EMAIL PROTECTED] Betreff: Re: [GENERAL] German special characters Problem Amin Schoeib

Re: [GENERAL] German special characters Problem

2003-09-09 Thread Amin Schoeib
change the encoding on the existing database 'test' -Ursprüngliche Nachricht- Von: Amin Schoeib Gesendet: Dienstag, 9. September 2003 16:13 An: Dennis Gearon Cc: [EMAIL PROTECTED] Betreff: Re: [GENERAL] German special characters Problem So what can I do that I don't get w

[GENERAL] Converting database-encoding from SQL_ASCII to UNICODE?????

2003-09-12 Thread Amin Schoeib
Title: Converting database-encoding from SQL_ASCII to UNICODE? Hi, I have a database with encoding SQL_ASCII. Now I need to convert the encoding to UNICODE. Can somebody tell me how I can do that Thanxx Schoeib 4Tek Gesellschaft für angewandte Informationstechnologien mbH Sc

[GENERAL] Between(Interval of two dates) in Postgres

2003-09-12 Thread Amin Schoeib
Title: Between(Interval of two dates) in Postgres Hi, can somebody tell me How I can use the Oracle between function in Postgres? Like this: Select name from test Where date_f between '31.01.2000' And '31.01.2003' Thanxx Schoeib 4Tek Gesellschaft für angewandte Informationstechn