> > create table tmp (create_datetimestamp);
> >
> > #insert into tmp values('2001-04-01 02:29:52');
> > INSERT 1021715 1
> >
> > #select * from tmp;
> > create_data
> >
> > 2035-05-29 01:33:36-05
> > (1 row)
Before start PostgreSQL on FreeBSD. Set environmen
Help me, please.
Can I create a 2 Parallel Server with clustrering DB PostgreSQL?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
Alex wrote:
> I've just install PostgreSQL 7.1.1 and noticed that timestamp have changed
> in this release.
> for example:
> CREATE TABLE "foo" ( test timestamp );
> if you "\d foo" you will notice the column test is not a timestamp, it's a
> "timestamp with time zone"
> anyway, how can I make a t
INM1=# explain select ref_num from grls where ag_id in (24);
Index Scan using grls_ag_id on grls (cost=0.00..597.87 rows=849 width=12)
IMN1=# explain select ref_num from grls where ag_id in (select 24);
Seq Scan on grls (cost=0.00..992.44 rows=30195 width=12)
SubPlan
-> Materialize (cos
John Aughey wrote:
> I'm stress testing my application by creating large data sets. This
> particular query selects rows from the schedule table that have a specific
> owner_id. (I'll show you the results of explain)
>
> calendar=# explain select * from schedule where schedule.owner_id=101 or
IMN1=# explain select count(*) from grls WHERE active = 10;
NOTICE: QUERY PLAN:
Aggregate (cost=993.21..993.21 rows=1 width=0)
-> Seq Scan on grls (cost=0.00..992.44 rows=307 width=0)
IMN1=# explain select count(*) from grls WHERE popularity = 10;
NOTICE: QUERY PLAN:
Aggregate (cost=23.2
hiroko wrote:
> from a DB table, I'd like to SELECT out the date of 3months before.
> the command should be
>
> => select * from MYTBL where time =XX ;
>
> what whould it like to be at X ?
Try this:
SELECT * FROM mytbl WHERE create_date > (now() - '3 month'::interval) ;
See date/time
Dennis Muhlestein wrote:
> I'm interested in finding companies that use java and postgres in a
> production environment. If anyone knows of any url's I could visit or has
> experience with this in their own company, I'd love to hear about it.
www.linux.org.ru
FreeBSD, PostgreSQL, Java
Info and
