Hello,
I have a 'big problem' :
I have to show some data from two identical databases so I need to run a
querry (view, ..etc) on both databases and show the united result ...
Any ideea how to obtain this result ?
Thank You,
Adrian Din
--
Using Opera's revolutionary e-mail client: http://www.oper
Hello,
I have a little problem
I want to declare a type record for later use like that
create type record_structure1 as (id int2, nume text);
that is ok!
next in a function I want to use something like that:
select * from table as record_structure1 ?
instead of writing
select * from table as t1(id
Hello,
I am want to use a private table in postgresql(every client to see his own
data).
Is this possible? How can I do it!
Thank you,
Adrian Din
--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
---(end of broadcast)---
TIP 9:
that others
can help too.
Din Adrian wrote:
On Thu, 03 Feb 2005 13:56:50 +, Richard Huxton
wrote:
Please CC the mailing list as well as replying to me, so that others
can help too.
b) in docs say that after 7.2 seting this to false does'n turn off
the wall ...!? wich o
the round sintax is
round(numeric,int)
not
round (double,int)
you must cast the value into numeric:
ex: round (cast(doublecolumn as numeric),2) should work ok
Adrian Din,
Om Computer & SoftWare
On Sun, 27 Feb 2005 15:26:07 -0800, TJ O'Donnell <[EMAIL PROTECTED]> wrote:
I received the following err
we are using postgresql8 +psqlodbc8+ delphi7 ... the only problem is the
server side cursor = doesn't work properly ... so we are using client side
for datasets :)
On Wed, 15 Jun 2005 23:49:29 -0400, Postgres Admin
<[EMAIL PROTECTED]> wrote:
I have a client who wants to use Delphi
<[EMAIL PROTECTED]> wrote:
So you installed psqlodbc 8 on the client machine with Delphi installed,
correct? What problems did you have with cursors? Any other
suggestions?
Thanks a lot for the help!
J
Din Adrian wrote:
we are using postgresql8 +psqlodbc8+ delphi7 ... the only pr
We tested also (pgExpress Driver) - is faster then psqlodbc but we have a
problem with it:
it does requery (or refresh? - I don't remember exactly) after every post
in database.(for us this is a problem - if you have more then 10.000 in
current dataset loaded when you add a new record and pos
TECTED]> wrote:
Hi Adrian,
You're right. What we did was include one "refresh" button and inserted
one configuration that after x seconds the component refresh the screen
(query).
If you find a better solution, please inform me.
Regards,
Rodrigo
Din Adrian wrote:
We
An example(found it some time ago somewhere ?! :) ):
/*
drop view a_and_b cascade;
drop table tbla cascade;
drop table tblb cascade;
*/
CREATE TABLE tbla
(
id int4 NOT NULL,
a int4,
b varchar(12),
CONSTRAINT tbla_pk PRIMARY KEY (id)
)
--WITHOUT OIDS
;
CREATE TABLE tblb
(
id int4 NOT NULL,
Hello,
I have a 'big' problem:
I am trying to run from a procedure a function witch generate a new
document number (max from table +1 ) and after to insert a document with
this number, but the function returns me the same number each time because
the tranzaction is not finished and the inser
Yes , I know what sequence is, but our procedure for generating doc
numbers is v. big and has manny (4) parameters and we did'nt use sequence
in it for this reason
any other advice ?
thak you,
Adi
On Mon, 04 Jul 2005 14:47:16 +0200, Zac <[EMAIL PROTECTED]> wrote:
Din A
t;get_me_next_number" function)
thank you,
Adria Din
On Mon, 04 Jul 2005 17:27:20 +0200, Zac <[EMAIL PROTECTED]> wrote:
Din Adrian wrote:
Yes , I know what sequence is, but our procedure for generating doc
numbers is v. big and has manny (4) parameters and we did'nt use
se
e
update MagMaxNrBon set maxnrbon=vNrBon where magazie =
dsgroup.magazie_implicita_lansare;
end if;
...
and in this way vNrBon is correct one ... I will try to use oly
execute on insert,update and select on temp table MagMaxNrBon
(o_gen_calc_nr_doc is the "get_me_n
I am sorry but:
the table is TEMPORARY ... I don't need to do any lock on it
(eventualy I should do a lock on the table where I want to insert the
documents - the MagMaxNrBon is only a temp table used for storing the max
document nr for each user's setings in this transaction - I did that
Any function runs into a single transaction so you don't need to worry
about rolling back on exceptions - this is the standard behavior. If there
is an exception while running any statement inside the function it's
rolls back automatically.
On Tue, 05 Dec 2006 17:25:31 +0200, Marian POPE
16 matches
Mail list logo