Dear Sirs,
I am a graduate studant, and for doing a homework I need details how Postgre, keep
information, does it uses B tress,or B+ tree or just binary trees.
I would apreciate all help you can give me.
Sincerely,
Henrique Lima
---(end of broadcast)
Last line just before EXAMPLES
http://www.us.postgresql.org/postgresql-7.3.3/sql-createfunction.html
Highlighted:
http://216.239.33.104/search?q=cache:soHhFN4V1IMJ:www.us.postgresql.org/postgresql-7.3.3/sql-createfunction.html++site:www.us.postgresql.org+default,+only+the+owner+%22%2Bof+%2Bthe+func
> "RJ" == Ron Johnson <[EMAIL PROTECTED]> writes:
RJ> On Thu, 2003-09-04 at 15:40, Doug McNaught wrote:
>> Bjørn T Johansen <[EMAIL PROTECTED]> writes:
>>
>> > Should one use pg_dumpall to backup the database or is it more practical
>> > to just copy the data directory?
>>
>> The data direct
Lincoln Yeoh <[EMAIL PROTECTED]> writes:
>> That's a documentation error. Where do you see it exactly? I can't
>> find such a statement in the current sources.
> Last line just before EXAMPLES
> http://www.us.postgresql.org/postgresql-7.3.3/sql-createfunction.html
Ah. Looks like it's already b
Tom Lane writes:
> That has nothing whatever to do with how much memory the kernel will
let
> any one process have. Check what ulimit settings the postmaster is
> running under (particularly -d, -m, -v).
My ulimit settings you requested look ok (others included for info)
ulimit -d, -m, -v : un
Dear all,
Is there a way to obtain more information about error messages, eg. the
name of the column which generates an error ?
I find it problematic that when some operations cause an error, there is
no feedback about the complete error, eg. when I do an INSERT into a
field, which exceeds the fi
Hi this is my code of sql select
SELECT
a.f_codigo_cliente,
a.f_fecha_inicio_vigencia,
a.f_fecha_fin_vigencia,
b.f_nombre,
b.f_apellido,
e.f_chassis,
e.f_placa,
e.f_registro,
e.f_color,
e.f_year,
g.f_descripcion_marca,
f.f_descripcion_modelo
FROM
Hi, all,
I tried to use "left join" to select data from my
database. Result is come out, but I didn't see the
value of "displayString". I added "left outer join",
same result.
SELECT devices.ProductType, devices.deviceKey,
devices.fullDNSName, deviceTypesEnum.displayString,
deviceTypesEnum.enu
> I tried to use "left join" to select data from my
> database. Result is come out, but I didn't see the
> value of "displayString". I added "left outer join",
> same result.
sounds like deeviceTypesEnum.enumID don't correspond to
devices.productType.
Jo
>
> SELECT devices.ProductType, device
--- "scott.marlowe" <[EMAIL PROTECTED]> wrote:
> On Fri, 5 Sep 2003, CSN wrote:
>
> >
> > --- "scott.marlowe" <[EMAIL PROTECTED]> wrote:
> > > On Fri, 5 Sep 2003, CSN wrote:
> > >
> > > > Since you usually need to know the total
> number of
> > > > rows a query would return, do you think it's
>
On Friday 05 September 2003 18:07, Edwin Quijada wrote:
> Hi this is my code of sql select
>
[snip]
> This select get 20 seconds to doing. My 2 first table has 50 reords
> each one
>
> Explain
> Merge Join (cost=79.44..7127.72 rows=226 width=347)
> Merge Cond: ("outer".f_w
- Original Message -
From: "Jeffrey Melloy" <[EMAIL PROTECTED]>
To: "shreedhar" <[EMAIL PROTECTED]>
Cc: "Postgre Admin" <[EMAIL PROTECTED]>; "Postgre General"
<[EMAIL PROTECTED]>
Sent: Friday, September 05, 2003 7:32 PM
Subject: Re: [GENERAL] How can I set postmaster as a service
> shree
--- "scott.marlowe" <[EMAIL PROTECTED]> wrote:
> On Fri, 5 Sep 2003, CSN wrote:
>
> > Since you usually need to know the total number of
> > rows a query would return, do you think it's
> better
> > to:
> >
> > a) Do one query with a LIMIT and OFFSET to get the
> > results, and another COUNT qu
Hi guys!
I need to migrate some plpgsql functions I have to C language.
These functions execute queries and process the results inside, and some of them return records... I've been reading the documentation, but I would like any of you to tell me where can I find some examples of these kind o
On Fri, 5 Sep 2003, CSN wrote:
>
> --- "scott.marlowe" <[EMAIL PROTECTED]> wrote:
> > On Fri, 5 Sep 2003, CSN wrote:
> >
> > > Since you usually need to know the total number of
> > > rows a query would return, do you think it's
> > better
> > > to:
> > >
> > > a) Do one query with a LIMIT and
scott.marlowe wrote:
> On Fri, 5 Sep 2003, CSN wrote:
>
> > Since you usually need to know the total number of
> > rows a query would return, do you think it's better
> > to:
> >
> > a) Do one query with a LIMIT and OFFSET to get the
> > results, and another COUNT query to get the total
> > numb
On Fri, 5 Sep 2003, CSN wrote:
>
> --- "scott.marlowe" <[EMAIL PROTECTED]> wrote:
> > begin;
> > declare bubba as cursor for select * from table
> > order by fieldname;
> > move forward 100 in bubba;
> > fetch 5 from bubba;
> > rollback;
> >
> > Then you get the same kind of effect, but only 5
>
"Edwin Quijada" <[EMAIL PROTECTED]> writes:
> This select get 20 seconds to doing. My 2 first table has 50 reords each
> one
The row counts mentioned in your explain output seem suspiciously small.
Have you ever ANALYZEd or VACUUMed these tables?
regards, tom lane
--
Franco Bruno Borghesi writes:
> I need to migrate some plpgsql functions I have to C language.
> These functions execute queries and process the results inside, and some
> of them return records... I've been reading the documentation, but I
> would like any of you to tell me where can I find some
> I think I have found out why.. I have a where clause on a ID field but it
> seems like I need to cast this integer to the same integer as the field is
> defined in the table, else it will do a tablescan.
Yes, this is correct
> Is this assumtion correct? And if it is, do I then need to change al
On Fri, 2003-09-05 at 09:39, Jonathan Bartlett wrote:
> > I think I have found out why.. I have a where clause on a ID field but it
> > seems like I need to cast this integer to the same integer as the field is
> > defined in the table, else it will do a tablescan.
>
> Yes, this is correct
>
> >
On Friday 05 September 2003 19:20, Neil Conway wrote:
> On Fri, 2003-09-05 at 06:07, Richard Huxton wrote:
> > PG's parser will assume an explicit number is an int4 - if you need an
> > int8 etc you'll need to cast it, yes.
>
> Or enclose the integer literal in single quotes.
>
> > You should find
Neil Conway <[EMAIL PROTECTED]> writes:
> On Fri, 2003-09-05 at 06:07, Richard Huxton wrote:
>> You should find plenty of discussion of why in the archives, but the short
>> reason is that PG's type structure is quite flexible which means it can't
>> afford to make too many assumptions.
> Well,
23 matches
Mail list logo
