ive/runtime-config-client.htm
l#GUC-TIMEZONE
--
Brandon Aiken
CS/IT Systems Engineer
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rodrigo Sakai
Sent: Thursday, December 21, 2006 12:33 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL]
Hi all,
I'm having some troubles with time zones! I have a database dump file that
have the date fields stored as '2006-12-20 00:00:00-02'!
And I have to restore it in a database that has the time zone configured as
'BRST' (-3 from GMT). So, when it is restored the value becomes '2006-12-19
2
Hi, I have a question about how to insert data in
composite types!
Imagine the exemple:
CREATE TYPE t_time AS
(
a date,
b date
);
CREATE TABLE salary
(
salary numeric(10,2),
t_date t_time
);
I know that if I want to insert data in the table
SALARY I just
Hello all,
I’m developing a specialist application
that needs a different kind of referential integrity! I need interval
referential integrity where the bounds of the referenced interval must overlaps
(or be equal) the bounds of the referencing interval!
For example,
-
Hi,
Anyone knows a good tool for do the reverse engineering
of a postgresql database? I tried to use DBDesigner, but I couldn’t get the
relationships!
Thanks!
Hi all,
I need some help to create types to use
in a table. For exemple, I want to create:
CREATE TYPE salary_type (
value
NUMERIC(10,2),
date DATE
)
CREATE TABLE employee (
num_employee
INT,
name VARCHAR(60),
salary salary_type
)
I know I ne
attention!!
- Original Message -
From: "Brad Nicholson" <[EMAIL PROTECTED]>
To: "Simon Riggs" <[EMAIL PROTECTED]>
Cc: "Rodrigo Sakai" <[EMAIL PROTECTED]>; "Michael Glaesemann"
<[EMAIL PROTECTED]>;
Sent: Friday, February 24, 2006 1
overy, but it
implements a kind of temporal functionality because it keeps track the exact
time (transaction time) that a transaction commited.
Thanks for your help!
- Original Message -
From: "Simon Riggs" <[EMAIL PROTECTED]>
To: "Rodrigo Sak
chael, I will have a look on the Date's article.
- Original Message -
From: "Michael Glaesemann" <[EMAIL PROTECTED]>
To: "Rodrigo Sakai" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, February 23, 2006 10:43 PM
Subject: Re: [GENERAL] Temporal Databases
On
Hi
everyone,
I'm
focus on temporal databases (not temporary), and I want to know if anyone here
is studying this tecnologies too. So, we can exchange knowlegment. Specifically,
anyone who is trying to implement on postgresql the aspect of time
(temporal).
These
researches are le
10 matches
Mail list logo
