[GENERAL] Function

2017-10-27 Thread Marcio Farah
Good morning for all I´m beginer in PL/pgSQL functions and I have one difficulty. The function bellow should return many records but return just one. The loop just do the first INSERT INTO and get out. CREATE OR REPLACE FUNCTION geo_output.funcao30(num integer) RETURNS TABLE (quadro_id integer,

[GENERAL] Situation with delphi7 x postgresql 8.1.2

2006-02-09 Thread Marcio
 Hi, I develop under Delphi7(Build 8.1) pgexpress 4.01 and postgreSQL 8.1.2 OS is windows XP Professional or Windows 2003 Server. In my project i use dbexpress components TSQLConnection, TSQLQuery -> TDataSetProvider -> TClientDataSet. In some situations when the TClientDataSet excute action

[GENERAL] Multicolumn Indexing using R-Tree

2004-02-03 Thread Marcio Caetano
Hello ! I'm using PostgreSQL 7.3.2 and I need to create a R-Tree index that uses more than one column in a table. When I run the instruction it appears this message bellow: DefineIndex: access method "rtree" does not support multi-column indexes How can I solve this problem ? Is it a limitati

[GENERAL] Specifying a index

2004-02-03 Thread Marcio Caetano
) my SELECT will use in a query ? If so, how ? Thanks in advance. Marcio Caetano. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html