Sorry!!
It works very well!
Renaud THONNART
> Renaud Tthonnart <[EMAIL PROTECTED]> writes:
> > I would like to know how I can get the number of elements of an array.
>
> There is a function that returns an array's dimensions as a text string:
>
> regression=# s
Tom Lane wrote:
> Renaud Tthonnart <[EMAIL PROTECTED]> writes:
> > I would like to know how I can get the number of elements of an array.
>
> There is a function that returns an array's dimensions as a text string:
>
> regression=# select array_dims( &
Jose Manuel Lorenzo Lopez wrote:
> Renaud Tthonnart schrieb:
> >
> > Good morning everyone,
> >
> > By declaring a PgDatabase variable like this, I know that I make a
> > connection to the DB 'test'
> >
> > PgDatabase data("dbname
Good morning everyone,
By declaring a PgDatabase variable like this, I know that I make a
connection to the DB 'test'
PgDatabase data("dbname = test");
How to end connection?
By making this?
delete data;
regards, Renaud THONNART
---(end of broadcast)
Tom Lane wrote:
> Renaud Tthonnart <[EMAIL PROTECTED]> writes:
> > I would like to know how I can get the number of elements of an array.
>
> There is a function that returns an array's dimensions as a text string:
>
> regression=# select array_dims( &
Christopher Sawtell wrote:
> On Thu, 01 Mar 2001 21:53, you wrote:
> > Good morning all,
> >
> > I would like to know how I can get the number of elements of an array.
>
> create function array_element_count(_int4) returns integer as '
> declare
> a alias for $1;
> i integer;
> begin
> i
Good morning all,
I would like to know how I can get the number of elements of an array.
regards,
Renaud THONNART
Can I create object and methods with postgreSQL.
And how?
Thank in advance,
Renaud THONNART
If I can't use nested tables, how can I create a
type that will be a kind of "dynamic list of structure".
regards,
Renaud THONNART
How can I create nested tables ?
I haven't find how it can be made in the doc.
Could someone give me a little example to create and then insert in
nested table?
Thank you.
Renaud THONNART
Tom Lane wrote:
>
> Do a VACUUM ANALYZE, for starters. These results look like the planner
> is working with the initial default estimates for a never-vacuumed table.
>
>
> Indexes might be a good idea too.
> http://www.postgresql.org/devel-corner/docs/postgres/indices.html
> has a good intro to
Here they are :
EXPLAIN
(SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.RA BETWEEN 3 AND 5);
NOTICE: QUERY PLAN:
Hash Join (cost=25.02..60.98 rows=33 width=20)
-> Seq Scan on exposure_epic e (cost=0.00..22.50 rows=333 width=16
This qwery takes about 2 seconds :
SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.RA BETWEEN 3 AND 5;
This one about 5 seconds :
SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
Stephan Szabo wrote:
> On Wed, 21 Feb 2001, Renaud Tthonnart wrote:
>
> > How can I use sequences in a stored procedure written with pl/pgsql?
>
> What exactly are you trying to do? Pretty much you can call the
> sequence functions you want to use on the sequence name yo
How can I use sequences in a stored procedure written with pl/pgsql?
Thanks in advance!
Renaud THONNART
15 matches
Mail list logo
