Search found 4 matches
- 05.06.2015, 08:33
- Forum: ZeosLib 7.2 Forum
- Topic: Bag or not with Params TZquery
- Replies: 0
- Views: 1341
Bag or not with Params TZquery
I'm use only 1 TZquery component for many queries. Database PostgreSql like select * from public.p_test1(:id, :b, :c) :id is integer param :b, :c other params no matter what types then other query select * from public.p_test2(:id, :d, :e) :id is integer[] param (array) :d, :e other params no matter ...
- 13.08.2012, 11:11
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Query Bug with stored function and table
- Replies: 5
- Views: 2273
- 13.08.2012, 04:34
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Query Bug with stored function and table
- Replies: 5
- Views: 2273
here.
I install from "svn://zeos.firmos.at/zeos/trunk" and "Zeos.inc" have rows
I install from "svn://zeos.firmos.at/zeos/trunk" and "Zeos.inc" have rows
Code: Select all
//PATCH TO DO NO METADATALOADING / UNTESTED HIGH RISK
{.$DEFINE FOSNOMETA}
- 12.08.2012, 19:54
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Query Bug with stored function and table
- Replies: 5
- Views: 2273
Query Bug with stored function and table
Hi! I work with Potgresql. Any heavy queries I build with stored functions. And what I found. Some times If I join function with table(view), some fields have the wrong datatype. Like this CREATE OR REPLACE FUNCTION p_test () RETURNS TABLES( A bigint, B integer ) $body$ DECLARE ... BEGIN ... return;...