"[EMAIL PROTECTED]" wrote:
>
> I have a database with several tables that use timestamp without time
> zone type. I upgraded from an older pgsql and have code that does not
> expect the precision in the select output. Is there a way I can get the
> effect of zero precision without modifying all th
That's a good one, but it has the disadvantage of
giving a null result row:
insert into test values ( '2004-12-22' ) ;
The SELECT from below gives
result
31
33
25
(null)
42
(5 rows)
Also, I am not sure about the order of values.
Anyway, Béatrice, thanks for your
Perhaps it will be better if you put an 'order by' in the select.
SELECT
(( select test1.date
from test test1
where test1.date > test.date order by date limit 1)
- test.date ) AS result from test order by date;
result
42
31
33
25
Re
I have a table that looks like:
Column | Type | Modifiers | Description
-+--+---+-
from_id | integer | not null |
to_id | integer | not null |
val | numeric(4,3) | |
Indexes:
"correlation_pkey" PRIMARY KEY, btree (
I answer my own question, if only for my own records. The following
query is about 5-6 times faster than the original. Of course, if
anyone else has other ideas, I'd be happy to hear them.
Sean
explain analyze select from_id,to_id,val from exprsdb.correlation where
from_id in (select to_id
Sean Davis wrote:
I answer my own question, if only for my own records. The following
query is about 5-6 times faster than the original. Of course, if
anyone else has other ideas, I'd be happy to hear them.
Sean
explain analyze select from_id,to_id,val from exprsdb.correlation where
from_i
Hi,
I have a requirement where I have a table and a view on top of it. I want to
make some changes so that a user in a given group would be able to insert/update
only on the view (ofcourse i have a rule which inserts/updates the table) but
not on the underlying table. I tried revoke the insert/upda
On Tue, Mar 22, 2005 at 02:28:08PM -0700, [EMAIL PROTECTED] wrote:
> I have a requirement where I have a table and a view on top of it. I want to
> make some changes so that a user in a given group would be able to
> insert/update
> only on the view (ofcourse i have a rule which inserts/updates t
- Original Message -
From: "Richard Huxton"
To: "Sean Davis" <[EMAIL PROTECTED]>
Cc: "PostgreSQL SQL"
Sent: Tuesday, March 22, 2005 3:59 PM
Subject: Re: [SQL] Self-referencing table question
Sean Davis wrote:
I answer my own question, if only for my own records. The following
query i
hello guys,
I need help. I have functions but it is saved to pg_toast, when I
dump the database, the function from pg_toast is not copied. so is
there any sql or syntax to view function data ?
Thanks
Ricky
---(end of broadcast)---
TIP 9: the plan
On Wed, Mar 23, 2005 at 11:39:31AM +0800, bandeng wrote:
> I need help. I have functions but it is saved to pg_toast, when I
> dump the database, the function from pg_toast is not copied. so is
> there any sql or syntax to view function data ?
What exactly do you mean by "it is saved to pg_toast
Hello, bandeng.
March, 23 2005, 8:39:31:
b> hello guys,
b> I need help. I have functions but it is saved to pg_toast, when I
b> dump the database, the function from pg_toast is not copied. so is
b> there any sql or syntax to view function data ?
xxx:=\d pg-catalog.pg_proc
xxx:=select procsrc
MN> March, 23 2005, 8:39:31:
b>> hello guys,
b>> I need help. I have functions but it is saved to pg_toast, when I
b>> dump the database, the function from pg_toast is not copied. so is
b>> there any sql or syntax to view function data ?
MN> xxx:=\d pg-catalog.pg_proc
xxx:=\d pg_catalog.pg_pro
13 matches
Mail list logo
