Hello Developers
what had drove you to use CSTRING type
for input argument of postgres-type input convertion functions (in general)
and for output of postgres-type output conversion functions
?
thanx
---(end of broadcast)---
TIP 6: Have you
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
Hello,
I have the following tables in my db
Painter (id integer, uri varchar(256)) and
paints (id1 integer, id2 integer)
I want to optimize the question
select id from Painter where uri = 'x';
What kind of index (Btree or Hash) is more efficient to create on field
uri since it'
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
hi all
i have a table like this
id_message int4 not null default nextval ( ...
id_abonneint4
texte_message varchar() not null
date_message numeric not null
the default size of numeric is 30.6
another table :
id_message int4
id_abonneint4
text_message text
date
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
Hi, my name is sherril .I have the following Question
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
Also tell me how to retreive all records from database where field which is
date time is nu
12 matches
Mail list logo
