On Mon, 28 Mar 2011 08:26:03 -0700, Rob Richardson
wrote:
I have a table that records a starting time for a process and the length
of time that process will take, and I need to calculate the time the
process will end. I have the starting time both in local time and in
UTC time, but for reaso
On Tue, 09 Jun 2009 08:24:01 -0700, Brandon Metcalf
wrote:
CREATE TABLE foo (
start DATE,
length VARCHAR(10),
);
I need to be able to get one value for each column at any given time.
CREATE UNIQUE INDEX u ON foo ((start IS NOT NULL));
You would just make sure you SELECT FROM f
On Sun, 22 Aug 2010 10:27:52 -0700, c k
wrote:
Hi all,
As I am using MS Access for a long time, many tools like ms access
provides
a way to get the list of columns from a query. (using filed list in combo
boxes in ms access). But is it possible to get such list of columns from
a
query wh
On Wed, 15 Sep 2010 08:53:16 -0700, Carlos Mennens
wrote:
CREATE TABLE weather (
temp_lo int, -- low temperature
);
I did a search and don't understand in what aspect are the 'comments'
relevant / visible? I don't see the comments when I attempt to list /
describe the t
On Thu, 16 Sep 2010 06:22:15 -0700, Andreas wrote:
It's not only typos to catch. There is variation in the way to write
things that not necessarily are wrong.
e.g.
Miller's Bakery
Bakery Miller
Bakery Miller, Ltd.
Bakery Miller and sons
Bakery Smith (formerly Miller)
and the usual
Strawberry
On Mon, 2009-01-05 at 13:05 +0900, Craig Ringer wrote:
> alvar...@alvarezp.ods.org wrote:
>
> > On user account creation, the schema gets created and the interface
> > tries to do a "CREATE TABLE my_relation () INHERITS
> > (_skel.my_relation);" as the new role, but PostgreSQL returns the error
>
On Thu, 2009-01-29 at 13:16 +, Gregory Stark wrote:
> So, what do people say? Is Postgres perfect in your world or does it
> do some
> things which rub you the wrong way?
For me:
Lack of column-level privileges. It just doesn't help scalability at
all. You end up having different tables each
On Fri, 2009-01-30 at 15:32 -0500, Bruce Momjian wrote:
> Octavio Alvarez wrote:
> > On Thu, 2009-01-29 at 13:16 +, Gregory Stark wrote:
> > > So, what do people say? Is Postgres perfect in your world or does
> it
> > > do some
> > > things which
On Fri, 2009-01-30 at 14:25 +, Gregory Stark wrote:
> "Daniel Verite" writes:
>
> > Gregory Stark wrote:
> >
> >> Is it the hierarchical query ability you're looking for or pivot?
> >> The former we are actually getting in 8.4.
> >>
> >> AFAIK even in systems with pivot you still have to
On Sat, 2009-01-31 at 18:32 +, Greg Stark wrote:
> On Sat, Jan 31, 2009 at 5:34 PM, Octavio Alvarez
> wrote:
> >
> > It doesn't really matter. Since crosstabs are just a presentational
> > variation to a query with aggregate functions and GROUP BY clauses,
>
On Sat, 2009-01-31 at 23:36 +, Gregory Stark wrote:
> Octavio Alvarez writes:
>
> > A crosstab is not but a presentational transform of the data set. Any
> > information you would eventually need can be taken from the original
> > data source, one way or another. T
On Sat, 2009-01-31 at 15:54 -0800, Octavio Alvarez wrote:
> On Sat, 2009-01-31 at 23:36 +, Gregory Stark wrote:
> > Octavio Alvarez writes:
> >
> > What about a WHERE clause like
> >
> > WHERE P1 > P2
>
> You could either:
>
> (1) do &qu
On Thu, 2009-02-12 at 14:21 -0800, Adrian Klaver wrote:
> On Thursday 12 February 2009 11:37:37 am Paolo Saudin wrote:
>
>
> SELECT fulldate,sensor
> FROM (SELECT fulldate,sensor,count(sensor)
> FROM (SELECT 1 AS station, fulldate, meanvalue AS sensor FROM
> table1
> UNION
>
Hi, everybody!
I already solved it. Thank you.
First of, I forgot to mention the version(), so FYI, 7.4.1.
I followed Tom's advice in
http://archives.postgresql.org/pgsql-general/2004-03/msg01073.php
I shut down the PG instance.
postgres -D $PG_DATA -O -P $DBNAME
=# REINDEX DATABASE tbc_gamma
14 matches
Mail list logo
