Alexaki Sofia <[EMAIL PROTECTED]> writes:
> But as I see from the query plan the indexes are not used, instead
> sequential search is done either I define indexes or not.
> As you can see below the query plan remains the same.
> Is that reasonable??? Shouldn't Postgresql use the indexes in order
Hello,
I have the following tables in my database
Painter(id integer, uri varchar(256))
paints(id1 integer, id2 integer)
in order to speed up the join (select * from painter, paints where
painter.id= paints.id1) between these two tables I have created indexes
on the field painter.id and/or pa
Alexaki Sofia <[EMAIL PROTECTED]> writes:
> I can either define the field id as a Primary Key or create an Btree index
> on it. What is more effient??
> From my test I see that creating Btree index is a bit faster!!.
I think you're seeing things. Declaring a field primary key creates
a btre
Ange Michel POZZO <[EMAIL PROTECTED]> writes:
> select datetime(abstime( floor (value) ));
> select datetime(abstime( int4 (value) ));
> select datetime(abstime( numeric_int4 (value) ));
> in all case :
> ERROR: pg_atoi: error in "952969611.00": can't parse ".00"
That was fixed in Janu
On Thu, 3 Aug 2000, Ange Michel POZZO wrote:
> Le jeu, 03 aoű 2000, Karel Zak a écrit :
> > > my question is how can i convert the numeric or the int4 value to
> > > a date value?
> >
> >
> > test=# select abstime(965293003);
> > abstime
> >
> > 2000-08-03 10
Le jeu, 03 aoû 2000, Karel Zak a écrit :
> > my question is how can i convert the numeric or the int4 value to
> > a date value?
>
>
> test=# select abstime(965293003);
> abstime
>
> 2000-08-03 10:56:43+02
> (1 row)
>
> Ka
> my question is how can i convert the numeric or the int4 value to
> a date value?
test=# select abstime(965293003);
abstime
2000-08-03 10:56:43+02
(1 row)
Karel
On Fri, 26 May 2000, Sherril Mathew wrote:
> My one feild in the database is Date/time I want to find a range of
> records which exists between two dates in the same date field in the
> database
SELECT * FROM table WHERE datetime_field between '1999-03-15' and
'2000-10-23';
> Also tell me
