Search results for query: *

Hi, I want to create a report that will use a temporary table in vb6 with "create temp table as select ....". is it possible? i use postgres as dbms thanks for your help fodil

Hi, From the clients, i need to run the same view but with different parameter in order to generates reports with crystal (Chrystal report uses the view ). is it possible? if yes show me how please. thanks a lot.

Hi, i have a query that returns about 6000 records. when i do EXPLAIN ANALYZE, the time estimated is 1500 ms. When i try to fill a recordset with ADO it tooks more than 35 second !!. is it problem of odbc? thanks for your help fodil

Hi, I have a database on postgres server, i noticed that i lose space disk just by trying select queries, and when i use VACUUM command, it takes a lot space. i wander if it uses a temporary files without deleting them when the action is finished. if yes, tell me please the name and the place...

Hi every body, I have postgresql version 7.1.3 installed on AIX OS, and an ODBC version 7.1.9. I tried to execute simple sql query on my PC using the odbc, and it was very slow. the same query on the AIX machine is very quick. i don't know if there is something to do in order to make...

Hi, I have a stored function created in a postgres database, that function returns an integer value and i want to run that function from VB using ADO. I used with vcmd .CommandType = adCmdStoredProc .CommandText = "fn_insertdata" 'fn_insertdata is the...

Hi, i've postgres version 7.1.3 and is runing on AIX, the ODBC driver i'm using is version 7.1.9. In my table there is 44 fields all of them are of type VARCHAR,FLOAT8,DATESTAMP. also i have 3 indexes and one primary key. i'm using windows 95. and i'm using pgadminII to open the database...

Hi, I have a large table that i imported from MsAccess, i tried a simple query on MsAccess and on Postgresql, and i noticed that postgres is very slow to load the table, and some times he loose the connection to the database completly The query is like : select * from table, my table is...

Hi every body, I need to use DISTINCTROW in my sql statement, but the parser of postgres doesn't accept it. the following sql statement doesn't work on postgres SELECT DISTINCTROW field1,field2 FROM TABLE when i replace "distinctrow" with "distinct" it works. if...