Dnia 2003-06-20 07:12, Użytkownik Együd Csaba napisał:
Hi All,
here are my three tables. I wold like to list them in the following way: I
need all the columns from t_stockchanges, and one field for the
productgroup
the t_stockchanges.productid belongs to.
But one product can belong to many gro
Dnia 2003-06-20 07:12, Użytkownik Együd Csaba napisał:
Hi All,
here are my three tables. I wold like to list them in the following way: I
need all the columns from t_stockchanges, and one field for the
productgroup
the t_stockchanges.productid belongs to.
But one product can belong to many grou
Hi All,
here are my three tables. I wold like to list them in the following way: I
need all the columns from t_stockchanges, and one field for the
productgroup
the t_stockchanges.productid belongs to.
But one product can belong to many groups, so i would need one row for each
group for each p
On 17/06/2003 10:22 zhuj wrote:
hi,all:
I want to constraint the maximum number of concurrent connections to
25
in postgres
jdbc driver. There are no methods for this
change. How would i do?
The simplest way is to use a connection pool.
HTH
--
Paul Thomas
+--+-
On Thursday 19 Jun 2003 1:38 am, Marcin Winkler wrote:
> I have 1 function in pg 7.3.2.
>
> txt string have 1,2,3,.. and i would like to be similar like if 3 in
> (1,2,3..) then, but IF 3 in (||txt||) THEN doesn't work.
> There is possible to this or not ?
> txt := ;
>
I have 1 function in pg 7.3.2.
txt string have 1,2,3,.. and i would like to be similar like if 3 in
(1,2,3..) then, but IF 3 in (||txt||) THEN doesn't work.
There is possible to this or not ?
CREATE OR REPLACE FUNCTION rek2(INT8) RETURNS text AS '
DECLARE
i
Hi
I realized I made a mistake. :(
The example below should have :
create view all_data as
select ...
The "as" statement was missing.
Here is a real sample of a function allowing a similar effect :
--- sql script ---
--
-- delete old function [must be done before type is dr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 19 June 2003 04:41, Anagha Joshi wrote:
> My client C++ front end is multi-threaded. The above 'transcation' block
> is in thread -y .
> I want to know the info. abt' last row inserted into table in this
> transcation block.
> Info contains
Consider this:
Transcation begin
'
'
Insert on table x
'
'
Trascation end;
My client C++ front end is multi-threaded. The above 'transcation' block
is in thread -y .
I want to know the info. abt' last row inserted into table in this
transcation block.
Info contains the details like time o
