[SQL] Case Insensitive comparison

hai   i am using postgresql 7.3.x. I am converting a database in MS SQL server to PostgreSQL.   The main problems i am facing is that in sql server the text comparisons are case insensitive. how can i compare text case insensitive in postgresql without using an upper() or lower() function in both

Re: [SQL] Case Insensitive comparison

Thanks to all of you for your valuable suggesstions does postgresql internally uses the = operator(text,text) for any other purposes. i think that overloading it solves the index problem too...     Tom Lane <[EMAIL PROTECTED]> wrote: Josh Berkus <[EMAIL PROTECTED]>writes:>> How can i create a f

[SQL] Temporary tables

hi, I am using postgresql 7.3.2. Is there any function to determine whether a table exists in the database.Or is there any function that returns the current temp schema.I am using a pl/pgsql function that create and drop a temporary table.The procedure run correctly for the first time for each data

Re: [SQL] Temporary tables

Thanks to all of you for your suggestions. the problem is solved by creating a function istableexist() that returns whether a table exist or not. the function is bellow. CREATE FUNCTION istableexist(varchar) RETURNS bool AS '  DECLARE  BEGIN      /* check the table exist in database and is visible

[SQL] Sorting problem

hi all, i am using postgres 7.3.2 .i am converitng a mssql database to postgres. now i am facing a strange problem. sorting based on a varchar field is not working as expected. the non alphanumeric characters are not sorting based on the ascii value of them.   i have the following table structure.

[SQL] Which is faster SQL or PL/PGSQL

hi, i am converting an MSSQL database to Postgres. there is a lot of procedures to convert. which language is best for functions, SQL or plpgsql. which is faster . i am using postgres 7.3.2 jinujose Do you Yahoo!? The New Yahoo! Shopping - with improved product search

[SQL] DateDiff in PostgreSQL

Hi, i am converting a MSSQL Server database to PostgreSQL. Using PostgreSQL version 7.3.2. Is there any function like the DateDiff() in MSSQL Server. ie, a function that returns difference of two dates(timestamp) in days or months or year.. The - operator for timestamp retuns the intervel in days

Re: [SQL] DateDiff in PostgreSQL

Yasir Malik <[EMAIL PROTECTED]> wrote: >You can use the age() function to find the difference between dates, and>use the extract() function to get the years, months, days, etc.>Yasir this will not work because age('25/12/1975','30/01/1986')wil return '10 year 1 month 5 days' extract only returns

[SQL] Infinite loop crashes server

hi all, i am using PostgreSQL 7.3.2 on redhat linux 9. there is problem when executing pl/pg sql functions. if the function enter an infinite loop. the server is hanged. cannot cancel the query. the linux itself is hanged.i cannot kill postgres process. i have to reboot the machine manually.. waite

[SQL] Distributed Transactions

Hi all,   i am using PostgreSQL 7.3.2. How can i do distributed transactions in PostgreSQL. is there a transaction coordinator available for Postgres..   thanks in advance regards jinujose Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want.

[SQL] Enterprice support in PostgreSQL

Hi all,   We are providing database solutions in postgreSQL...Now using PostgreSQL 7.3. It is performing well. But Now we have some enterprice level requirements. One of Our requirement is to provide a distributed solution in PostgreSQL. The questions are...1. Is it posible to provide a distributed